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?
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
> >
> >
> >.
> >
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks