Afternoon,

Can anyone please look at the attached workbook and figure out why the it won't send the email? (please ensure you change email address before testing). I have it working on another sheet but since I have added new columns (I have changed code to) it will no longer work, any help much appreciated.

Many thanks
Jason
Contract expiry test.v2.xls