Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Automatic Email Alerts Beni Excel Discussion (Misc queries) 2 May 29th 09 06:42 PM
Auto Numbering certificate generation scooterboy65 Excel Discussion (Misc queries) 2 September 17th 08 09:24 PM
Email alerts Frank Excel Discussion (Misc queries) 4 February 20th 07 08:35 PM
can you create alerts to notify you when somethng "expires" in a . tpen Excel Discussion (Misc queries) 3 April 11th 05 05:12 PM
Can I get email alerts when dates in excel are nearing? lucrecat Excel Discussion (Misc queries) 2 December 14th 04 05:14 AM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"