View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default New Workbook from all sheet of a workbook

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