Launching Outlook from withing access as a module and passing strings

  • Thread starter Thread starter Leanne
  • Start date Start date
L

Leanne

I'm tryin gto launch from an access table into a new email
note in outlook passing 3-4 strings through from the
access table - any ideas, I haven't been able to get the
application to optn.
 
There are a couple of ways to send an Outlook email from within Access. One
of the simpler is to use the SendObject method, which you can check out in
VBA Help.

You might also want to investigate using Automation with Outlook. There is
sample code at the following link 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