Emailing PDF reports from Access

[CraigMc]

Presently, I am emailing some reports from Access via a simple macro created.
The reports are emailed in the MS Snapshot format. Well, I would like to
email the reports in the PDF format. I have Adobe Professional and of course
everybody has or should have Adobe Reader. I would rather email the reports
in PDF, but that does not appear to be an option. How can the reports be
created in PDF format and emailed?

know I can print the reports to the Adobe printer option, but that is not so
friendly of a process. I would like to use a macro or some other script.
Please note I have limited knowledge of Access.

 

[Jeff C]

Presently, I am emailing some reports from Access via a simple macro created.
The reports are emailed in the MS Snapshot format. Well, I would like to
email the reports in the PDF format. I have Adobe Professional and of course
everybody has or should have Adobe Reader. I would rather email the reports
in PDF, but that does not appear to be an option. How can the reports be
created in PDF format and emailed?

know I can print the reports to the Adobe printer option, but that is not so
friendly of a process. I would like to use a macro or some other script.
Please note I have limited knowledge of Access.

Doing a search of this site I found references to printing to an adobe
printer and references to cutepdf which is shareware that converts
most everything to PDF format if you do not own the full Adobe
package. Since you are using the maco to print your .snp format, use
the macro to print your report and assign the printer for the report
to be CutePDF (assuming you get the shareware and install it). This
will give you the prompts to save the file in PDF format. I am not
very advanced in Access but I think the only way to automate the
report generation and e-mail prompt is though VB code but I may be
wrong.

 

[CraigMc]

thanks. I do have the Adobe full version. But, even there I have to respond
to the prompts. Perhaps the answer is that I need the VB code written. I hope
somebody can advise further on the topic.

 

[Ofer]

Take a look at http://www.granite.ab.ca/access/pdffiles.htm.
or
The snapshot format includes a viewer you can send with
your report the
first time (for those who don't have Access) There are
several free pdf
creators available too. Just google for: CutePDF or PDFCreator

There are several. You'll need GhostWriter and the print
driver. Have a look
at http://www.cutepdf.com for one of them. Others at:

http://www.pdf995.com/
http://www.primopdf.com/

 

[Arvin Meyer [MVP]]

I use Steve Arbaugh's PDF and Mail Class which does work with Adobe, but is
significantly faster and less error prone with Win2PDF

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.win2pdf.com/

Between the code in the class module, and my own code, I have able to
create, save as pdf's, and send by email hundreds of PO's per hour, totally
automatically.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Igreen]

Can you tell me what code you used as I am struggling to automate my
invoicing via email, I can do it with the 'snapshot' view but I want to use
the PDF format - can you help?

I use Steve Arbaugh's PDF and Mail Class which does work with Adobe, but is
significantly faster and less error prone with Win2PDF

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.win2pdf.com/

Between the code in the class module, and my own code, I have able to
create, save as pdf's, and send by email hundreds of PO's per hour, totally
automatically.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Paul Shapiro]

I can send you the code I've written to create a pdf from either an Access
report or a Word document. Send me an email by removing the "hideme" if
you'd like a copy. It works with Adobe Acrobat versions from 5 to 8.

I haven't tried it, but someone else posted that in Access 2007 pdf is a
supported output format, once you install the free PDF/XPS add-in from
Microsoft. The code was simply:
DoCmd.OutputTo ObjectType:=acOutputReport, _
ObjectName:=argRPT, _ 'the report we are working with
outputformat:=acFormatPDF, _
outputfile:=strReportFile, _ 'path (drive, folder & name)
to put pdf in.
autostart:=True