Automatic e-mail notification upon expiry.

[popinz]

Hi,

I have a spreadsheet that contains active contracts. What I want to do is prompt a macro that will send an automatic e-mail when a contract is 6 mths , 3 mths and upon expiry.
Is there a way to do this?

Thanks in advance for the always great help
Have an awesome day!