Working with Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know if it is possible to write a script or program that looks at a field in my database and based on that data, send an email to personnel that their shipment is in. I would be using Access 2000 and Outlook 2000. I know you can do this manually, but for effciency I need it automated.
 
You certainly can do this - the technique is called "Automation". There is
sample code at the following links that can get you started:

MSDN article "Outlook for the Summer" (a how-to for creating appointments,
emails, etc., using Outlook Automation and recommended for beginners, IMO)
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

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


don said:
I need to know if it is possible to write a script or program that looks
Click to expand...
at a field in my database and based on that data, send an email to personnel
that their shipment is in. I would be using Access 2000 and Outlook 2000.
I know you can do this manually, but for effciency I need it automated.
 
Back
Top