Automated Email in Excel

Hi All,

I have a spread that generates an automatic email when a contract is due to end.

Currently, if the contract is due to end in the next 20 days an email will be generated.

I would really like to set this up so that I can generate a second email detailing that it is URGENT if the contract is due to end in 10 day.

I have attached my spread to this sheet.

If you can help I would be so appreciative.

Alice :-)