Before I ask my question, I have extensively Googled this and spent the whole morning finding articles that support older versions of Access and Acrobat.

I am using Microsoft Access 2000 with VBA code to drive my automation.
I am using Adobe Acrobat 6.0 Standard
I am using Lotus Notes 6.5

I have an MS Access 2000 application that generates separate reports based on criteria that I pass into a VBA routine. The reports can be one or 100 reports with one or many pages per report. Each report needs to be made into a separate PDF file for distribution by e-mail.

Today, I have to manually print each report to PDF through the printer control and then attach each to a separate e-mail.

How can I automate the process using MS Access 2000 VBA to do the following?
1) Using a loop, pass the criteria to my Access report to generate individual reports. (I can do this)
2) Print to PDF file using a file name and location that I generated in step 1 above
3) Optional, e-mail the created report using Lotus Notes to a e-mail address that I have from step1 above
4) Avoid any manual intervention such as navigating to the “save as” location and entering the PDF file name
5) Avoid Acrobat from displaying the document it just generated. I don’t need to view my reports.
6) Continue looping until all reports are generated

Finally, I want to avoid having to purchase a third party application / plug-in to do this.

I have also searched the Acrobat site, but have not been able to find anything there either.

Thank you for your help on this

Andre