How to email a file from within Access 2003

P

Paul Doree

Hi all,

I need to send emails from Access 2003. In particular, I need to send a
file (.pdf) which is sitting in a known loacation on the users C:\ drive.
The file will probably be open at the time.

I've looked at the docmd.sendobject but that only seems to allow access
objects to be sent (e.g. reports).

Any pointers?

Yours,

Paul
 
T

Tony Toews [MVP]

Paul Doree said:
I need to send emails from Access 2003. In particular, I need to send a
file (.pdf) which is sitting in a known loacation on the users C:\ drive.
The file will probably be open at the time.
Click to expand...

Will it be open as read only? For example by a PDF file viewer? Will that viewer
put a lock on the file so another program can also open that file>
I've looked at the docmd.sendobject but that only seems to allow access
objects to be sent (e.g. reports).
Click to expand...

To add to Alex's posting there are a number of different options depending on your
email app. Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top