multiple date based auto-email

[Blainec25]

I'm working on a project to track employee safety certifcations by date. Dates are entered on the day training was completed with up to 10 columns of different certifications and roughly 60 rows of employees. I have looked through all the threads I could find on automatic email generation, but i have almost 0 experience with VBA and some of the certifications expire in 3 years and other annually.

I need a code that will automatically generate and send an email to a supervisor informing them that an employees certification is expiring, but it has to be based on multiple columns with different lenghts of certification.

Any help is appreciated