Automating the download of rpts

[techexpressinc]

--------------------------------------------------------------------------------

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

 

[lameid]

What you want to do is very similar to another recent thread.

Check out thread703-1558861