Automated downloads of rpts how?

[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

 

[HiTechCoach]

Russ,

What version of Access are you using?

I would recommend using a form to enter the data range. Then have all 9 report's record source reference the form for the dates. This way you only have to enter them one.

This may help:
Report Dialog Examples