Hi,

I have a sheet to monitor the contracts where start and end date of the contract is mentioned in columns i.e. C2 (01 Aug 2012 Start date) D2(31 Aug 2012 End date).

My requirement is that 5 working days before the end date, A email should be sent by the macro to a predefined address with following details

Subject: Contract expiry 31 Aug 2012

In body:
Paste special the column: A2 to E2

My data base looks like -

A1 B1

SL no Name