Create Email to automaticaly send email based on Renew Date

I have set up a spreadsheet with renew dates , which is 3 months before expiry date


I would like a macro to send an email automatically based on renew data in Col C. The email contents is in sheet "Email"



Your assistance in this regard is most appreciated

I have written code to email a recipient where "yes" appears in Col G. Where "Yes" Appears in Col "G", then I want the header as well as the rows "Yes" to be emailed to the recipient"


I cannot get the code to do this


it would be appreciated if someone could kindly amend my code