Is there any way to send a report via e-mail using a PDF format

[Bob]

I created a database that produces a report that needs to
be emailed. I currently have it set up to send an email
attachment in a snapshot format. However, many of the
recipients don't have snapshot viewer and don't want to
download it. I have been asked to try and find a way to
generate the email attachmetn as a PDF file instead. Does
anyone know how to do this?

 

[Peter R. Fletcher]

You would have to print it to a PDF "distiller" driver and then pick
up and send the output file from VBA.

I created a database that produces a report that needs to
be emailed. I currently have it set up to send an email
attachment in a snapshot format. However, many of the
recipients don't have snapshot viewer and don't want to
download it. I have been asked to try and find a way to
generate the email attachmetn as a PDF file instead. Does
anyone know how to do this?

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Jim/Chris]

There are several free pdf creators available. Just google
for: CutePDF or PDFCreator

Then you would email the file created in the previous step.

Jim

 

[Guest]

but how can you automate the process of creating the pdf of a report and
having access open a new email and insert the pdf file into it....then all
you have to do is enter the email address and a subject??