Multiple access reports into one pdf file

[Lloyd]

I am a CPA who uses Access 2007 to create multiple reports for various
clients. Typically, I use a macro to email them directly from access and to
output to a specific folder on my computer. When there are multiple reports
involved, I am aware of three options: 1) output the reports to a folder and
attach them to an email where the recipient must deal with multiple files; 2)
send each report as a separate email; or 3) select the Adobe icon that
‘converts multiple reports’.

I seek a solution whereby I can use a macro to email or output preselected
reports in one pdf package? I use Adobe Acrobat Professional V 8.1.2

 

[Tony Toews [MVP]]

I am a CPA who uses Access 2007 to create multiple reports for various
clients. Typically, I use a macro to email them directly from access and to
output to a specific folder on my computer. When there are multiple reports
involved, I am aware of three options: 1) output the reports to a folder and
attach them to an email where the recipient must deal with multiple files; 2)
send each report as a separate email; or 3) select the Adobe icon that
‘converts multiple reports’.

I seek a solution whereby I can use a macro to email or output preselected
reports in one pdf package? I use Adobe Acrobat Professional V 8.1.2

I'm sure Adobe Acrobat Pro can be automated from Access to combine
reports into one PDF file. However I have no idea how as I've never
worked with Adobe Acrobat Pro. I'd suggest poking about Adobe's
website looking for either VB6 or VBA code. There are some links at
http://www.granite.ab.ca/access/pdffiles.htm which might be of
assistance.

That said Stephen Lebans free solution does that as well and only
requires two dlls to be copied into the same folder as your FE
MDB/MDE.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/