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


.