How to deal with multiple people requesting to order parts, then auto send and email to the customer at the end of the week

Hi there , so I like to be able to send an e mail once a week to order parts that the guys over ordered over the week, also we need to maybe order parts from an other customer there and have an the email ready to go once its been approved. What would be the best way to do this. Thanks :)