Send Email Based on 2 Dates

Hello all, this is my first thread and have looked at others but can't find a solution.

I need a VBA code that sends an email to the same email address every time TODAY() date matches the date on 2 difference cells.

Please refer to the attached file:

If TODAY() matches any date in Column D (i.e. D2 [10/1/2015]):

Email should read: Hello John Doe, the contract for School Board Of Mdc (A2) will expire in four months from today, TODAY() on 2/1/2016 (B2).

If TODAY() matches any date in Column C (i.e. C2 [8/1/2015]):

Email should read: Hello John Doe, the contract for School Board Of Mdc (A2) will expire in six months from today, TODAY() on 2/1/2016 (B2).

I am using Outlook 2013 and Excel 2013 on Windows 7 Professional.

Thanks. I appreciate your help!

How about:

Please Login or Register  to view this content.

Oops. Missed an End If.

Please Login or Register  to view this content.

When I transfer the code to the real spreadsheet I'm working with I get a Type Mismatch error. Please take a look at the code:

Please Login or Register  to view this content.

Thank you again!

The code should let you know which line error'ed out.

The most likely culprit is

Please Login or Register  to view this content.

if the value being compared is an error itself.

Try using

Please Login or Register  to view this content.

to try to supress the error.