If you use outlook (not outlook express), the you can use code to attach any
file you want, including a pdf file.
To create the pdf file, you can use Stephens free pdf creator here:
http://www.lebans.com/reporttopdf.htm
The advantage of the above pdf creator is that you
a) don't have to install a printer driver
b) don't have to change the output printer, or switch pdf printers
in code
c) don't actually have to install any software, but just place a
..dll in the same
directory as the mdb (or mde) appcation.
When all is considered, the above issues means that Stephen Solution runs
circles around the other two suggestions here.
If you use outlook, then your code can just attach the pdf file created....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com