Hi! I would like to know if anyone can help on my issue.

It's that I need to send emails to a certain set of email contacts based on the dates mentioned in an excel file. The dates correspond to deliverables that are due, but have/have not been submitted on those respective dates. The file can be sent to you if you would like to review the same. A preceding email message would also need to go in the auto-email.

Trailer no. Item Activity Due Date 1st delayed date 2nd delayed date 3rd delayed date Total days of delay Status
A Tank Detailed design 26/12/2014 04/01/2015 Received on 20/12/2014
A Tank Tank GA drawing 16/12/2014 19/12/2014 23/12/2014 24/12/2014 8
A Tank Detailed drawings 15/12/2014 20/12/2014 received on 21/12/2014
A Trailer Detailed design 16/12/2014 19/12/2014 23/12/2014 24/12/2014 8
A Trailer GA drawing 15/12/2014 20/12/2014 31/12/2014
A Trailer Detailed drawings 16/12/2014 19/12/2014 20/12/2014 03/01/2015 18
B Vessel Detailed design 15/12/2014 20/12/2014 received on 21/12/2014
B Vessel Tank GA drawing 16/12/2014 19/12/2014 23/12/2014 24/12/2014 8

The email message would read something like this:
Dear Team,

Below is the list of delayed Activities of the project as of today, 042 Jan 2015.
Total delay on each item is also highlighted. Please submit the pending documents without further delay.
Trailer no. Item Activity Due Date 1st delayed date 2nd delayed date 3rd delayed date Total days of delay Status
A Tank Detailed design 26/12/2014 04/01/2015 Received on 20/12/2014

Best regards,

In other words, the email would extract the content of the rows where the macro has identified delay based on the current date.

Is there a macro you could help me with to make this possible?

Thanks so much for your assistance.