Hey all,
I'm a VBA newbie who is trying to use a list from an excel worksheet to send email reminders to those that have there reservation expiry date in column K highlighted in red. my code works for the 1st email address but not the rest. Also in the body of the email i have the drawing number (Column B) and date (Column K) associated to the email address. I wanted my code to loop through column K and send email reminders to the email address in column L that have there date in Column K highlighted in red. In the body of the email i would like it to tell the recipients the drawing number and the reservation expiry date. I have attached a screenshot of the worksheet layout. I appreciate any help I can get.
Thanks Guys
ps. I'm using excel 2010 if that helps
screenshot.jpg
Bookmarks