B
Bendmac
I've built an Excel database to keep track of training certificates for a
group of volunteers. Some of these expire every 1-3 years, the certificates
are earned at different times throughout a calendar year and there's 85
volunteers, so too many files to hand-search on a regular basis. If I enter
the date a particular certificate was earned, and then code it with a date,
say, 90 days before it's due to expire, is there a way to get that alert sent
to the particular volunteer and myself via email as a reminder that they are
due for recertification? Is this even doable in Excel, or is this better
addressed in Access? Thanks in advance!
group of volunteers. Some of these expire every 1-3 years, the certificates
are earned at different times throughout a calendar year and there's 85
volunteers, so too many files to hand-search on a regular basis. If I enter
the date a particular certificate was earned, and then code it with a date,
say, 90 days before it's due to expire, is there a way to get that alert sent
to the particular volunteer and myself via email as a reminder that they are
due for recertification? Is this even doable in Excel, or is this better
addressed in Access? Thanks in advance!