Create Macro - VBA to send mutiple emails based on a criteria

This is my first post on this Forum. I heard great things about this forum. I hope I get this right.
Attached is an example of a spreadsheet that I would use. I would like to create a control button that sends an email from Outlook to specified recipients based on the criteria below:
When the date in column G (Calibration Due) equals one week before the current date an email would be sent to the Leader from Column E.
I need all of the information from that specific row in the email. The subject in the email should state: Calibration plus the contents of column A (tool ID).

Would it be easier if I added a column with each individual?

Thanks

Hi John, Thanks for the response. I added the two columns per your request. Attached is the updated spreadsheet.Cal Code TestRev2.xls