How to send a consolidated report to fulfillment

My business collects adresses from a squeeze page and then sends them a kit with CD’s when they sign up. Right now I am manually consolidating a weekly report to send to the shippers telling them to send out the kits to the following clients.

How can I automate this?

NOTE: I do not want to send a whole bunch of emails, just a daily or weekly summary of the ones that need to go out today.

Thanks!
Robin