Send Email with attachment

[jamesormi]

Hi,

Does anyone have any idea on how to send an email with a file attached using VBA?

Any code examples would be greatly appreciated.

Thanks in advance.

 

[MarkK]

Do a search on 'CDO' or 'Collaboration Data Objects'. There are a bunch of examples of this already handled on this site.
Cheers,

 

[ianclegg]

I Find the easiest way is to use docmd.sendobject

eg

docmd.sendobject acsendtable,"audits",acformatxls,"To email Addres","CC Address etc",,"Subject"

see the format in the helpfiles

Regards

Ian Clegg

 

[jdraw]

I believe you can only send an MSAccess table, query etc via sendobject.
Take a look at this link for some code that has Access opening Outlook and sending an email with attachment.
http://www.blueclaw-db.com/access_email_send_outlook.htm

good luck