vba command to email attachments using Access 2007

J

Jer

I have several files (C:\PDA\graph1.pdf, C:\PDA\graph2.pdf,etc) to attach to
an email.

docmd.sendobject does not support attachments. Does another command exist?

Note that the Acrobat addin does not support charts. It messes up the
x-axis interval labels!
 
P

Piet Linden

I have several files (C:\PDA\graph1.pdf, C:\PDA\graph2.pdf,etc) to attachto
an email.

docmd.sendobject does not support attachments.  Does another command exist?

Note that the Acrobat addin does not support charts.  It messes up the
x-axis interval labels!
Click to expand...

If you dig around in the newsgroups or the internet, there are
examples of Outlook automation all over the place. Here's one...
http://www.amazecreations.com/datafast/CodePages/CodeOutlookMail.asp
 
Top