free pdf email question

[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/ =-

 

[Guest]

Take a look at the following postings they should have the info you seek.

http://www.mvps.org/access/reports/rpt0009.htm

http://groups.google.ca/group/comp....read/thread/26503b4528901186/a551f5a4a0eeb56d

 

[Albert D. Kallal]

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.

 

[Guest]

One free pdf writer that does allow automation is PDFCreator. you can get
some sample code from

http://www.excelguru.ca/node/22

Look through his excel archive for different examples (although used in
excel you can pretty much copy/paste the code into access).

PDFCreator can be found at http://sourceforge.net/projects/pdfcreator/ and
is completly free (open source). You can also find code by googling a bit.