[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

[Mattlynn via OfficeKB.com]

Hi
You can send a sheet speratelty.
File, Send to mail recipient. The Single sheet should be sent to the
recipient in the body of the email, regardless of how many sheets in your
workbook.
try it by sending to yourself first.

Matt




jai wrote:
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

--
Matt Lynn

Message posted via http://www.officekb.com

[Gord Dibben]

See Ron de Bruin's sendmail site.

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


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 23:52:00 -0700, jai wrote:

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

[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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jai" wrote in message ...
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