ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I code auto email alerts when a certificate expires? (https://www.excelbanter.com/excel-programming/397888-how-do-i-code-auto-email-alerts-when-certificate-expires.html)

Bendmac

How do I code auto email alerts when a certificate expires?
 
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!


All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com