How to send a E-Mail message with an attached file from Access?

A

Amadeu Cayuelas

I've tried to use 'SendObject' method, but I don't know the way to attach a
simple file to the Mail message.
 
C

Cheryl Fischer

You might want to investigate using Automation with Outlook. There is
sample code at the following links that can get you started:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm
 
A

Amadeu Cayuelas

I was trying to avoid Automation, but I will examinate your suggested links.
Thanks a lot anyway!
 
Top