Send emails from excel spreadsheet when expiration date approaches

Hello everyone,

I am quite new to excel but have lots of interest to work things out about this topic as it is very interesting to my field.

I would need the excel to notify me via email as a person responsible, but also my contract manager when certain contract is closing expiration (for renewal procedure). So once a column Termination notice is activated, id est when a date indicated there comes, just an email with subject renewal and body which would be a text of column Name - so we know what contract it is. Obviously, if this could be done on a regular basis, without me having to sit in the file all the time. Hope I don't ask way too much.

Any help would be greatly appreciated...

Thanks Slavica