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

  • Thread starter Thread starter Bob
  • Start date Start date
B

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?
 
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?
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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
 
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??
 
Back
Top