Automatic Email from Excel based on Date in Cell

Can someone help me to create email reminder automatically from Excel Worksheet using VBA or with other methods attached copy of the sample template sheet. We are creating 3 to 5 CAPA forms on daily basis for deviation issue, individual sheets are created and saved in one folder called CAPAF and numbered as per the CAPA number (D10, in the template). We need to create email reminder for corrective/preventive/document actions based on the responsibility persons selected for the task (criteria as per the note in the template) email reminder to the responsible person, CAPA leader and to executive director. email reminder should go automatically until the CAPA leader marked the task as completed. Since we are creating 3 to 5 capa's daily basis, very hard to keep on track on the outstanding tasks. Are any possibility to create weekly outstanding task with target due date? any suggesting would be appreciated