Using one report and exporting to individual PDF files

[lucy1216]

I am not that familiar with Access; however, I have managed to set up my tables, queries and reports.



The report contains expenditures which are grouped by Approver.

What I need to do is create multiple PDF files (could be some other format) that can be emailed to each approver.

Does anyone know how to do this? I have seen this question on multiple forums, but no answers.

I am not familiar with visual basic or XML, but certainly willing to jump into it if someone out there can assist me.

Thank you.

[pbaldy]

This should get you started:

Emailing a different report to each recipient

2003 did not have built in PDF capability, so you can use this to create one:

http://www.lebans.com/reporttopdf.htm

[lucy1216]

Thank you very much...I will attempt it over the weekend.

[pbaldy]

No problem, and welcome to the site by the way. Post back if you get stuck; there's a lot of info there.