New Adobe Professional 6 user seeks Quick answer!

[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?

THANKS!!!!!!!!!!!!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200507/1

[Larry Linson]

Let me see, I replied to this identical question in another newsgroup and my
reply doesn't show up here. That would tell me that you are multiposting,
not crossposting. Please take a look at the FAQ at
http://www.mvps.org/access/netiquette.htm.

This isn't the place to get Adobe answers either, even if you are using it
to make PDFs of Access reports.

Larry Linson

"Andre L via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:51***********@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?

THANKS!!!!!!!!!!!!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200507/1

[Andre L via AccessMonster.com]

Sorry, I did a search on Adobe and saw many responses to other Adobe/Access
related issues. My goal was 2 part, get an answer to my Adobe question and
then determine how to fire up Adobe from within Access thus keeping all the
work essentially in one app. This (Adobe) was actually a reccomended
solution of distributing rpeorts to user without losing the formating that .
RTF files create. Again, Sorry....

Larry Linson wrote:

Let me see, I replied to this identical question in another newsgroup and my
reply doesn't show up here. That would tell me that you are multiposting,
not crossposting. Please take a look at the FAQ at
http://www.mvps.org/access/netiquette.htm.

This isn't the place to get Adobe answers either, even if you are using it
to make PDFs of Access reports.

Larry Linson

We run numerous Access reports which we auto export as .rtfs to a share.
We

[quoted text clipped - 29 lines]

THANKS!!!!!!!!!!!!

--
Message posted via http://www.accessmonster.com