Sending email and text reminders once delivery date is met picking up from excel sheet

[mity]

Hi Everyone!

I need your help in sending automated email and text message, when the due date of a PO is a week away from the current date.

In the attached excel file, An email should go of to -email address (Col. E), with subject "PO (Col. A) is due on Delivery date(Col. C)", and body "Vendor (Col. D), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. G) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found most of threads using Outlook only ,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks