Another requirement for sending email from vba outlook

Hello everyone,

i needed some help in coding the macro, the question is in the attachment below..

Any help is appreciated

Thanks in Advance

Attachment : PDCLIST.xlsx

How does this differ to this http://www.excelforum.com/excel-prog...vba-excel.html?

If it differs, show us how far you've got and what you've tried

@ joshshaji

the question is in the attachment below..

You should clearly state what your question is within your post. You shouldn't expect someone to download your file just to see what the question is.

Hi Kyle,

thanks for the interest

This post is totally different from the previous post, the previous post was about sending more than one email by collecting information( recipient email,body of the email etc..) from excel sheet, however this post is about an automated email from an excel list of post-dated-cheques.

The PDC list comprises of hundreds of post-dated-cheques having various maturity dates. The requirement is to trigger an automated email one day prior to the maturity date consisting of all such PDCs with entire contents of the row as body of the email.

Please refer to the attachment in the post for better clarity.[/B]

thanks

Josh