Emailing PDF reports from Access

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.

--
CMac

On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc"
wrote:

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.

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.
--
CMac


"Jeff C" wrote:

On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc"
wrote:

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.

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/


"CraigMc" wrote:

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.
--
CMac


"Jeff C" wrote:

On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc"
wrote:

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.

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

"CraigMc" wrote in message
news
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.
--
CMac


"Jeff C" wrote:

On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc"
wrote:

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.

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?

"Arvin Meyer [MVP]" wrote:

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

"CraigMc" wrote in message
news
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.
--
CMac


"Jeff C" wrote:

On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc"
wrote:

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.

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

"Igreen" wrote in message
...
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?

"Arvin Meyer [MVP]" wrote:

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

"CraigMc" wrote in message
news
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.
--
CMac


"Jeff C" wrote:

On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc"
wrote:

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.