Send email when there is no change in data...

[Inquisitor99]

I need to send automatic emails to different recipients based on data that has not changed for a certain amount of days. Most of the posts I have looked at in this forum are for the opposite - send an email when data has changed.

Here is an example for my case:

Field value = "Pending". If this status has not changed to "Completed" in 10 days, send an email on the 11th day to the recipients to notify them that the status has not changed. Since there is no user intervation involved when the status has not changed, I cannot use any of the access form events. How can I tell when it's time to send the email?

Is this done through MS Scheduler, Outlook Tasks, directly in Access? I need to know what trigger I can use to send the emails. Can someone please point me in the right direction.

Thanks.

 

[belovedcej]

I would create an AutoExec macro that runs when the program is first opened. Then it would check daily, at the beginning of the day, and send an email.

 

[Inquisitor99]

Thanks belovedcej. I considered that option, but it only works if the database is actually opened daily. What if the database is not opened for a few days? It's possible that is the only solution, but I would like to know if there are any other options are available that I may not be aware of.