I'm looking at trying to build a macro that will automatically send e-mails to personnel within 1 week of becoming due for a review (column E). I've attached the spreadsheet I'm looking at using. The macro will need to send an e-mail to the person in column A via email address in column B (email to: ) and to the email address in column c (email cc: )
I would like to include a subject and subsequent body paragraph that will be standard for all personnel. This doesn't seem to difficult however, I have zero knowledge on VBA. Any help would be greatly appreciated.
Bookmarks