free pdf email question

  • Thread starter Thread starter whistler
  • Start date Start date
W

whistler

I have a report that I would like to email as a pdf attachment. I have "free pdf" installed that will create pdf files.

It is possible of course to print the report to the "pdf printer", and save/send the pdf from within the free pdf application.

Anybody who can drop a hint how i could fully automate the process ? I.e. open the report, save a pdf file to disk and email that through one vba code from within a form ?

regards, Jos


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
 
The best approach is to drop the use of a printer driver like free pdf.

They general allow you to print to a printer, but DO NOT allow you to use
code to automate, and create a pdf file of your choosing.

So, your best bet is to use the free pdf creating liberty here:

http://www.lebans.com/reporttopdf.htm

The above code is free, designed *specify* for ms-access, and further DOES
NOT requite you to install a pdf printer. This makes it VERY easy to install
your access application on a target machine, and NOT have to worry if they
have a pdf system installed.

The process would thus be:

create your pdf file, give it a file name...save it..

launch outlook via automation, and attach that pdf file.
 
Back
Top