Hi Fellas,

I should send email in outlook to my leads on daily basis.For this i need to write a macro.
In sheet 1 my data will look like below.

Criteria:
Macro should filter based on today's date.
ResourcesTask query mark Date
Jim VBM QTE 12 Jun 15,2012
Kun FRM RST 15 Jun 14,2012
har HFM LER 16 Jun 13,2012
Sheet 2
TO CC
[email protected] [email protected]
[email protected] [email protected]
[email protected]


In Sheet 2 and in Column "A" i have Email Addresses which should be placed in "TO" Section.
In Column "B" i have Email Addresses to be placed in "CC".

Subject: Today's date information:
Body of Email: should be sent like as is shown below.


Hi Sindy,

Please find details below as on date.
Resources Task query mark Date
Jim VBM QTE 12 Jun 15,2012
Best Regards,
Kandar Reply With Quote