Exporting Reports Question

[Blueridge227]

Running:
-Access 2007
-Adobe Acrobat 8 Professional

Currently our users are exporting reports one-by-one and then combining them after to a single pdf for printing.

Is there a way to export multiple reports to a single pdf file from Access?

any help is greatly appreciated!
thank you.

 

[Joe4]

I have never used this one myself, but I have heard of others using it, and it look like it might do what you want: http://pdfburst.com/features.html

 

[SydneyGeek]

Stephen Lebans has written some code that allows you to create PDFs from the Snapshot format -- not required for 2007 and higher -- and merge the reports.

I have used it to combine 3 reports into a single PDF, and email to the client. It works well but takes a while to understand how all the bits link together. If you're interested I could dig out the code and post here with some explanation.

Denis

 

[HiTechCoach]

I also use Lebans' ReportToPDF (click here) to combine PDF.

I also have clients that use the free PrimoPDF (Click Here). When saving you can select an existing file and will ask it you wan to append. Allowing you to combine the reports on the reports. I will even attached it to a new email message.