Windows 7 64bit 
Access 2010 64bit
I'd like to set up automatic emails for my database of projects. Each project has an end date, and I like Access to initiate and email notification open opening the database (that I can then alter and send manually) based on how for off the end date is. For example, for each project I'd like to have an email generated when the end date is within 15 days, 30 days, 60 days, and 90 days.
Because this database isn't opened on the weekends, access would need to know if an email has been sent at each of these intervals, and if not, generate and email at as soon as the database has been opened.
This gets even more complex given the fact that the end dates sometimes change. For example, one project may have an end date approaching in less than 30 days. Emails would already have been generated at this point. However, if the project's end date gets extended into the future (let say, another 60 days) I'd want access to again send an email at 15, 30, and 60 days.
Any tips? I've found some tutorials that describe how to send up automated emails, but none that address a situation quite like this...
Reply With Quote
