New Workbook from all sheet of a workbook

[jai]

Hi,

I have workbook having 100s of sheet. I have to e-mail each sheet to
different individual. Is it any way to do this tedious work more simply
rather making different workbook one by one and then email those sheet one by
one.

Thanks & regards

Jai

 

[Gord Dibben]

See Ron de Bruin's sendmail site.

http://www.rondebruin.nl/mail/folder1/mail2.htm


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

You can use one of the mail templates
http://www.rondebruin.nl/mail/templates.htm

Or use one of the two code examples if the mail addres is on the sheets
http://www.rondebruin.nl/mail/folder2/mail5.htm

Or
http://www.rondebruin.nl/mail/folder1/mail5.htm