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.
<COLGROUP><COL width=86><COL width=86><COL width=86><COL width=86><COL width=86></COLGROUP><TBODY>
</TBODY>
Sheet 2
<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.
<COLGROUP><COL width=86><COL width=86><COL width=86><COL width=86><COL width=86></COLGROUP><TBODY>
</TBODY>
Best Regards,
Kandar
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