View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default New Workbook from all sheet of a workbook

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