How to send automatic reminder email in MS Access 2010.

[Coolman]

Hello,

I created a Tracking System and would like to send an automatic reminder to the person the ticket has been assigned to, using the due date and the text message in the field "reminder message". Once the message send, I want the database to recognize and not send it again. I want the database to send a new message if the due date has changed.
Please help with the VBA code to do this. Your help is greatly appreciated.

Darius.

[June7]

What do you mean by 'automatic'? All code must be initiated by some event action - button click, data entry/edit, open form, close form, etc.

For Access to recognize message was sent, what would be the test - if sent date is Null or earlier than due date?

Sending emails is common topic in forum.

SendObject method is one approach.

[Coolman]

Hello,
Sorry if I wasn't clear. I have the following fields in my table frmHRSR: Assigned to; Due date; Message. The table contact contain user information such as email address, name etc... The data base is split on Front End Back End. I want Email sent out when the database is open using the text message in the field message, to the person the ticket is assigned to, 5 days before the due date. Any VBA code to help is welcome. Thanks in advance.

Darius

[June7]

Put code in Open event of form that is set to open by default when the database opens.

This is a common topic. Search forum and/or web. For a start, review https://www.accessforums.net/program...ook-21903.html