Filter based on today's date and send mail in outlook

[kandanuru]

Hi Fellas,

I should send email in outlook to my leads on daily basis.For this i need to write a macro.

Criteria:
Macro should filter based on today's date.

In sheet 1 my data will look like below.

Resources	Task	query	allocation	Date
marty	RTF	Continuation	100.00%	Jun 15,2012
smith	Icon	pending	100.00%	Jun 15,2012
Justin	CTR	Progress	100.00%	Jun 15,2012
wilson	RMF	Complete	0.00%	Jun 14,2012
Rajan	VPF	pending	100.00%	Jun 13,2012

<COLGROUP><COL width=86><COL width=86><COL width=86><COL width=86><COL width=86></COLGROUP><TBODY>
</TBODY>

Sheet 2

TO	CC
Sindy@xyz.com	parasu@xyz.com
suma@xyz.com	elizi@xyz.com
garbchoz@xyz.com

<COLGROUP><COL width=133><COL width=119></COLGROUP><TBODY>
</TBODY>

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	allocation	Date
marty	RTF	Continuation	100.00%	Jun 15,2012
smith	Icon	pending	100.00%	Jun 15,2012
Justin	CTR	Progress	100.00%	Jun 15,2012

<COLGROUP><COL width=86><COL width=86><COL width=86><COL width=86><COL width=86></COLGROUP><TBODY>
</TBODY>

Best Regards,
Kandar

 

[kandanuru]

Can any one pls look into the query.It's Important for me.....

 

[kandanuru]

Can any one pls look into the query.It's Important for me.....​

 

[kandanuru]

This is high priority ..pls look into the query

 

[kandanuru]

CAn any pls help me out on the query