Adobe Professional 6 Question....

[Andre L via AccessMonster.com]

We run numerous Access reports which we auto export as .rtfs to a share. We
also have numerous Excel sheets. Each month 10 or more of these reports are
combined into deprtmental monthly packets. We were given Adobe Acrobat
Professional 6 and told it could build the packet for us in an automated
fashion....ie it could convert the 10 or so reports to PDF format and merge
them into one file.

Manually I found this simple enough to do. Simply fire up Professional 6,
click: File then: Create PDF then: From Multiple files. Choose the files and
it converts each one to pdf format and combines all into a single file. Very
Nice!

Now I need to automate this as we desire to make the process more automated; .

....we want to make a script or something to do this for us each month...ie,
run Access/Excel and then click a button and walla...a pdf file containing
the 10 reports!

I see under Advanced there is Batch processing. This looks promising as I can
get it to open the files and convert them to pdf, however, it saves the
individually as opposed to merging them. How can I get it to open multiple
files and then save it as one big one. Do I need a java script? If so, anyone
care to share the code I would need?

 

[Larry Linson]

Where in the Access Menu hierarchy is the "Advanced" you mention? If it is
in the Acrobat menu hierarchy, then this isn't the newsgroup for the
question. This one is just for Microsoft Access database software.

Larry Linson
Microsoft Access MVP