Email to multiple persons
 

Hi All,
I hav a macro which generates a work sheet and names it as sheet2,sheet3
etc. Then I use Vlookup to fill in some entries in the new sheet. Now I want
to send this sheet to 5 to 10 persons whose email addresses are contained in
Cell D8 to Dx in another sheet named "Main".
I donot know how to define arrays for this.
Please help me out to accomplish this.
Thanks!

Email to multiple persons
 

Hi Telecommm,

See Ron De bruin's example code for emailing each recipient in a range:

http://www.rondebruin.nl/mail/folder3/message.htm


---
Regards,
Norman



"Telecommm" wrote in message
...
Hi All,
I hav a macro which generates a work sheet and names it as sheet2,sheet3
etc. Then I use Vlookup to fill in some entries in the new sheet. Now I
want
to send this sheet to 5 to 10 persons whose email addresses are contained
in
Cell D8 to Dx in another sheet named "Main".
I donot know how to define arrays for this.
Please help me out to accomplish this.
Thanks!

Email to multiple persons
 

Thanks !

"Norman Jones" wrote:

Hi Telecommm,

See Ron De bruin's example code for emailing each recipient in a range:

http://www.rondebruin.nl/mail/folder3/message.htm


---
Regards,
Norman



"Telecommm" wrote in message
...
Hi All,
I hav a macro which generates a work sheet and names it as sheet2,sheet3
etc. Then I use Vlookup to fill in some entries in the new sheet. Now I
want
to send this sheet to 5 to 10 persons whose email addresses are contained
in
Cell D8 to Dx in another sheet named "Main".
I donot know how to define arrays for this.
Please help me out to accomplish this.
Thanks!