Print multiple reports

G

Guest

Posted this before, but I'm going to try to clarify it better this time. I
have 9 reports, and I need to end up with four PDF files that each include
all 9 reports. The only difference is that each one will use different
criteria to generate the reports for a certain department. Obviously, each
pdf file needs to have a different filename.

I'm currently printing them to acrobat distiller, but I haven't figured out
how to write the code or use a macro to generate pdf files with names that
differ from the report name, and I definitely haven't figured out how to
combine each set of nine reports into a single pdf. Any help/advice is
appreciated. Thanks!
 
S

SA

Bagger:

To do this, you have to really run 4 different output jobs, creating and
merging the 9 PDFs four times.

If you look at our PDF and Mail Library, PDF Pro Plus edition, it will allow
you, with pretty simple code (sorry no macros) to automate the whole thing,
filtering the reports and then merging the nine into a single file with a
name and location of your choosing. Lots of VBA code examples in the help
file. You'll find it in the developer tools area of our web.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate PDF Bookmarks in MS Access 2007 Reports 1
ReportstoPDF - Multiple Pages 2
How do I print multiple access reports as one report or document? 1
Export or Print multiple reports from one Access Report by Group 3
Combining Access Reports into One Report using Acrobat Distiller 2
Reports to PDF 8
Automatically create multiple reports from a single report 1
Print Multiple Reports To PDF 2

Top