Using the Send Command to Email

  • Thread starter Thread starter Xcelsoft
  • Start date Start date
X

Xcelsoft

I want to use the send command in Access/Visual basic to
email a report to multiple customers. I will write a
simple loop to go down the list of customers to recieve
the email but I don't want to open the create mail window
each time. Is there a way to send the email directly to
the Outbox in Outlook???

Thanks,

Xcelsoft
 
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
 
Back
Top