I have a report that has 9 sections. I export to PDF and save it to My Documents and then email.

A new requirement, is that each of the sections is a separate document to be email. I could break it apart to 9 queries, run the reports entering a date range 9 times then saving to a PDF file.



Is there a way, VBA, or ? - that I could automate the run of the 9 sections download them to My Documents as 9 separate files?

Thanks
Russ