A Amadeu Cayuelas Feb 14, 2004 #1 I've tried to use 'SendObject' method, but I don't know the way to attach a simple file to the Mail message.
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 Feb 14, 2004 #2 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
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 Feb 14, 2004 #3 I was trying to avoid Automation, but I will examinate your suggested links. Thanks a lot anyway!
