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!