Hello everyone,
Sorta new to VBA macros but love learning the ropes. If someone could help build the template for this and I would be able to learn and build so much more to VBA macros for all my excel sheets just from the source code template.
I don't know if all this is possible exactly, but 90% sure.
Excel version is Microsoft 365.
So in my excel file, I have a column for names, different certs 1,2,&3 etc, and emails.
Currently have conditional formatting in the cert dates as:
Green = Valid
Orange = 30 days from now
Red = Expired
I am trying to set up a way to send an email to a team member if his/her certification is about to expire in 30 days and to send an email to a team member if his/her certification is expired.
With the Subject, Body, and Text to be formulated from a separate sheet.
Preferably would like to execute a toggle button to preform these actions; that way it does not send the email out every time the file is opened as the file has to be accessed multiple times throughout the week.
For testing purposes, I'll have the email display(.Display) but in actual production, would like it to send(.Send) automatically.
Let me know of any other required information to help get this going.
Bookmarks