vba command to email attachments using Access 2007

[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!

 

[Douglas J. Steele]

No, there's no other command in Access. You'll have to use Automation of
whatever e-mail client you're using.

Tony Toews has a good resource at http://www.granite.ab.ca/access/email.htm

 

[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!

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