Email Alerts

[Jaz]

Would this concept be possible:

I want a 1 to 2 table database that has a list of employees and their
training certifications with the expiration date. I would like the database
to automatically send an email alert if the expiration date is approaching.

Would this be possible in access? How difficult would it be to send email
alerts?

Thanks,
Jasper

 

[Arvin Meyer [MVP]]

It would be possible only if the database, and the machine it ran on, stayed
open while the code executed. It is quite easy to send email in response to
an event, like an expiration date. You simply poll the database, say once a
day, and send an email if a record is returned. Here's code to poll the
database when it opens every day:

http://www.datastrat.com/Download/Birthday2K.zip

and here's code to email:

http://www.datastrat.com/Code/OutlookEmail.txt