okay i am brand new to vba and macros and went through this and tried to figure it out but to no avail. do i use a separate code for each column? for an example for column D (DL. Exp.) i need an automatic email to send that lets me know that their driver's license expires in less than 30 days. then an email if column F is 30 days from expiring and the email to say cpr expires and same for G. im sorry as i said before i am brand new to this. Thanks for however can help me out.


Name D.O.H. DL Exp. CPR Exp. Ins. Exp. Med. Exp
Amekudzi Charlton 2/13/2013 11/20/2016 1/1/2015 4/2/2014 1/23/2015
Anderson Melissa 11/12/2012 1/4/2016 4/1/2014 4/30/2013 -
Anderson Robert 4/6/2013 5/20/2013 11/1/2013 1/4/2014 -