Email to multiple persons

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Telecommm - 17 Jan 2006 08:32 GMT

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!

Reply to this Message

Norman Jones - 17 Jan 2006 08:37 GMT

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

> Hi All,
> I hav a macro which generates a work sheet and names it as sheet2,sheet3
[quoted text clipped - 6 lines]
> Please help me out to accomplish this.
> Thanks!

Reply to this Message

Telecommm - 20 Jan 2006 08:23 GMT

Thanks !

> Hi Telecommm,
>
[quoted text clipped - 16 lines]
> > Please help me out to accomplish this.
> > Thanks!

Reply to this Message