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

 

[bhicks11 via AccessMonster.com]

There are a couple of products I can think of that, PDFCreate and CutePDF. I
know you can print multiple documents to the same pdf then you could attach
the doc. You can try them free and see if it works for you.

Bonnie
http://www.dataplus-svc.com

 

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

 

[Percus via AccessMonster.com]

Thanks, i'll try them.

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

[quoted text clipped - 6 lines]

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