How to Auto Generate an Email "Reminder"

[SeraGirl]

I have created a dbase to store information of Contracts. I have included a field 'Date to be Reviewed' I need detailed help on how I can make this field auto generate an email to Outlook on the date it contains to remind the user that they need to review the contract.

 

[Shortie]

Would this be something you would run daily? (i.e Click a button to notify all relevant parties that a contract is up for renewal) You could have a temporary table that listed all the contract numbers up for renewal. At the beginning of each day, the table is updated (semi-automatically). You click the button, the table is updated. For each record, an email is then sent to the relevant user, and the record is then removed from the temporary table.

Until you know exactly what you want, I can't get more detailed than that.

The other way is to use a timer event. For that, you dbase would require and additional field. Call it something like Notified (a Yes/No field) which defaults to No. Once a record is found that is due for renewal, and with Notified as No, an email is sent to the relevant user and the record is updated with Yes in the Notified field. Then once the review has been completed, the next review date is changed and the Notified field is set back to No.