KatieB1981
New Member
- Joined
- Dec 9, 2020
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi All,
I have created a spreadsheet in excel to record our staff tickets and qualification along with their expiry date. I have applied conditional formatting (colour code system) so that each cell changes colour when it is within 60 days of expiry. See attached as an example of the conditional formatting.
The question has now been asked whether VBA/Macros can be added to send out email notifications when qualifications are due to expire.
The message can be simple: "(NAME), (QUALIFICATION), is due to expire within 60 days. Please renew accordingly"
Can this be done? I am new to VBA - so any assistance and coding would be appreciated.
I have created a spreadsheet in excel to record our staff tickets and qualification along with their expiry date. I have applied conditional formatting (colour code system) so that each cell changes colour when it is within 60 days of expiry. See attached as an example of the conditional formatting.
The question has now been asked whether VBA/Macros can be added to send out email notifications when qualifications are due to expire.
The message can be simple: "(NAME), (QUALIFICATION), is due to expire within 60 days. Please renew accordingly"
Can this be done? I am new to VBA - so any assistance and coding would be appreciated.