By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

New Adobe Professional 6 user seeks Quick answer!

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.