Emailing worksheets within a workbook as ATTACHMENTS

I am trying to email each worksheet of a 150 worksheet workbook to a
different person or maybe a group of worksheets to a person BUT I want to do
it as an attachment NOT as in-line text. Is there any way to do this?

Catch 22 wrote:
|| I am trying to email each worksheet of a 150 worksheet workbook to a
|| different person or maybe a group of worksheets to a person BUT I
|| want to do it as an attachment NOT as in-line text. Is there any
|| way to do this?

Not in Excel natively, AFAIK, (Lotus will however....!). You will have to
copy each sheet or sheets to a different new workbook and email each one
separately.

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

hi,
see Ron's site on emailing from excel. lot of good tip
there. lot of sample code.

http://www.rondebruin.nl/sendmail.htm

>-----Original Message-----
>Catch 22 wrote:
>|| I am trying to email each worksheet of a 150 worksheet
workbook to a
>|| different person or maybe a group of worksheets to a
person BUT I
>|| want to do it as an attachment NOT as in-line text.
Is there any
>|| way to do this?
>
>Not in Excel natively, AFAIK, (Lotus will however....!).
You will have to
>copy each sheet or sheets to a different new workbook and
email each one
>separately.
>
>--
>Interim Systems and Management Accounting
>Gordon Burgess-Parker
>Director
>www.gbpcomputing.co.uk
>
>
>.
>

Thanks for the help!!

"[email protected]" wrote:

> hi,
> see Ron's site on emailing from excel. lot of good tip
> there. lot of sample code.
>
> http://www.rondebruin.nl/sendmail.htm
>
> >-----Original Message-----
> >Catch 22 wrote:
> >|| I am trying to email each worksheet of a 150 worksheet
> workbook to a
> >|| different person or maybe a group of worksheets to a
> person BUT I
> >|| want to do it as an attachment NOT as in-line text.
> Is there any
> >|| way to do this?
> >
> >Not in Excel natively, AFAIK, (Lotus will however....!).
> You will have to
> >copy each sheet or sheets to a different new workbook and
> email each one
> >separately.
> >
> >--
> >Interim Systems and Management Accounting
> >Gordon Burgess-Parker
> >Director
> >www.gbpcomputing.co.uk
> >
> >
> >.
> >
>