D Dwight Apr 29, 2004 #1 How do I send enail with multiple attachments? As far as I know SendObject will not work. Thanks in advance! Dwight
How do I send enail with multiple attachments? As far as I know SendObject will not work. Thanks in advance! Dwight
C Cheryl Fischer Apr 30, 2004 #2 Dwight, 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 (excellent, but simple, examples) 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
Dwight, 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 (excellent, but simple, examples) 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
