Copy that ope sheet to a new workbook and email that workbook as attachment.
OR
See Ron de Bruin's site for code and/or an add-in which will do the same thing
without the manual steps.
http://www.rondebruin.nl/sendmail.htm
Gord Dibben MS Excel MVP
On Fri, 7 Mar 2008 09:50:03 -0800, Marilyn
wrote: