Autoname and Create PDF or EXcel Files From Access

[razorking]

I have a relatively small database. It has in it data relating to orders. The orders table has maybe twenty customers and their corresponding open orders. The number of customers with open orders will fluctuate from month to month.

I want to send via e-mail a PDF or Excel file - monthly - showing the status of each customer's open orders. However I don't really want to create a new report fro each customer, instead I am looking for a way to just generate a separate report for each account that has open orders at the end of each month, and, preferably each report would be auto-named with the customer name.

Or in other words: I am trying to streamline a process so the user does not have to click and run twenty some odd reports and supply names for each, individually - it seems time consuming and open to possible keying errors.

Does anyone have any ideas?

Thanks!

 

[pbaldy]

I adapt this and the linked looping code:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm