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!