Automatic email from Lotus notes based on the due dates in excel

Hi all
I am new to this forum. Basically a mechanical engineer. We usually make minutes of meetings( Meeting document) in excel sheet. In this, we put action items against Target date of completion. When the target date is passed, we don't have any provision/method of reminding suppliers or stakeholders about their action items. Hence i need to develop a code so that i can send the reminders throug email automatically to the stakeholders. Sample excel sheet is attached.
Column A contains Action item, column B contains TDC and Column C contains the Mail id where email has to be sent.

I need the help of this forum to develop the code specific to my requirement.

Thanks in anticipation

Hello Ollie

Thanks for the wonderful reply.

I need to implement this so that i can check whether it is working or not. Mail id that i have mentioned in the sheet is mine only. Corrections in the mail body and other items can be made afterwards. So now just tell me how to put this script into action.

Regards
Vijendra

Thanks for the wonderful macro.

I believe we need to manually run the macro everyday. Can we make it auto run whenever we open it? Is there a better method of automating handling of the report.