Automate sending e-mail based on values in a database

[Mark]

Good Morning,

I have a database that tracks recurriing employee training dates. I am
looking for a way to send a training reminder via e-mail to an individual
based on a date calculation.

For example: It's determined (via calculation) that an individuals CPR
certificate will expire in 60 days. This would be the trigger to send an
e-mail to the individual an e-mail. The e-mail address is part of the
record, the subject would reflect CPR training Due 60 days and the message
body would reflect the last training date and repeat the subject line due in
60 days. It should count down until the training is completed and the data
updated (Due in 59, Duee in 58, etc.). If the training date expires it would
adjust the subject line and message body accordingly.

I track 15 different training dates for over 100 individuals. I have
reports that I can review on a daily basis and send out e-mail reminders
manually but it take alot of time. I've written macros for simple tasks but
I am at a loss as to how to code something on this scale. Any help would be
appreciated.

 

[chris.nebinger]

I searched google and this was the first result:

http://www.serverwatch.com/tutorials/article.php/1474711


Chris Nebinger

 

[Mark]

Thanks

At least now I have a jumping off point.