modify the VBA code to automatically send an email

Dear all,

I'm new to here and find this forum very useful. I am looking for help on solving these,


1. Check on the date in the column of F, H, J, L, N and P, automatically send an email to a in-charge and c.c to manage on 30 days before the expiration of the next training date.
2. In the column E, there is a pop-up calendar, and I will like to apply it to the column G,I, K, M and O.
3. For those expired date, i will like to change it to red color and record it in the "Course expiration.


I have been seacrhing and trying to do code for attached excel file but i cannot figure out how it will work as i m a newbie to VBA....anyone can help will be appreciated!