Automatically Send Email?

  • Thread starter Thread starter markmidwest
  • Start date Start date
M

markmidwest

I am creating a collection database & would like to have
a "Next Action Date" field. I would like the database to
generate an email if the Next Action Date is reached.

Can Access do this?

Thank you.
Mark
 
Sure. You would need a query to determine which records will generate
emails based on the value of the field, NextActionDate. Then, you can use
SendObject to create your email. If SendObject does not do everything you
need, then Outlook Automation is another choice. Here are links to some
articles that will 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
 
Back
Top