VBA code for Audit schedule email-weekly

Hello,

Can anyone help me with the VBA code for the following problem?

There are 30 candidates in our department who need an email reminder about the upcoming audit schedule.

Can any one give me the code for sending auto email from Excel?

If the current week is 21 , I want to send email to the people who have audit in the week 22. Sample excel sheet is attached.


Hense