Send Email with attachment (1 Viewer)

J

jamesormi

Registered User.

Local time

Today, 09:04

Joined

Nov 19, 2008

Messages

20

• Aug 12, 2010

• #1

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

bit cruncher

Local time

Today, 01:04

Joined

Mar 17, 2004

Messages

8,180

• Aug 12, 2010

• #2

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

 

I

ianclegg

Registered User.

Local time

Today, 09:04

Joined

Jul 14, 2001

Messages

58

• Aug 14, 2010

• #3

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

Super Moderator

Staff member

Local time

Today, 04:04

Joined

Jan 23, 2006

Messages

15,378

• Aug 15, 2010

• #4

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