How to send an E-Mail with attached file

[Peter Hibbs]

Hi

In Access2003 I want to send an e-mail with an attached file. The file
will usually be a .PDF file. My users will be using Outlook Express so
I cannot use MS Outlook code. The SendObject method can only send
Access objects (I believe) so is there any way to do this within
Access.

Thank-you.

Peter Hibbs.

 

[Rick Brandt]

Hi

In Access2003 I want to send an e-mail with an attached file. The file
will usually be a .PDF file. My users will be using Outlook Express so
I cannot use MS Outlook code. The SendObject method can only send
Access objects (I believe) so is there any way to do this within
Access.

You can automate the CDOSys library which should exist on any Windows 2000 or
newer PC. This does not provide a mechanism to show the message to the user
before sending and does not place a copy of the message in their SentMail
folder, but it's a good solution when those are not required.

 

[Al Campagna]

Peter,
A PDF printer driver should do the trick...
Stephen Leban's has Report to PDF @ http://www.lebans.com/reporttopdf.htm
Also, I've seen several suggestions for http://sourceforge.net/projects/pdfcreator/
Search the web under "PDF" "driver", there are many available (free and buy).

Also, since were discussing reports, noy PDF docs, you might want to consider using
Snapshot mode. While some PDF drivers have quirks, and may or may not translate all
formatting all the time... Snapshot is always a perfect copy.

--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Peter Hibbs]

Thanks guys. I will consider those options and see which works best
for me.

Peter Hibbs.