In an Access database there is a table named tblInvoicingMaster. In this table are four fields. One is named AnniversaryDate (date field), another is named ccEmpEmailAddresses (text field), and the 3rd one is named EmailReminderSent which is a yes/no field and the 4th one is EmailSentDate (date field).
What I want to make happen if it is possible is when the database is launched, have emails sent automatically. The criteria for sending the emails would be:
1) The checkbox field, EmailReminderSent = false
2) The current date is equal to or greater than the AnniversaryDate
When the email is sent each one must have a static subject line and a static email body text. Also when the email has been sent the field EmailReminderSent has to be flagged as true so the email doesn't get sent again any time the database is launched and also the 4th field in the table needs to be populated with the date the email was sent. Somehow this code would have to loop through all the records that meet the criteria.
Is this possible?