I often need to email a single worksheet within a workbook that has multiple
worksheets (tabs). When I do it by the icon Email, Send the current sheet as
the message body, it sends it out with no formating and is not in an excel
worksheet form. Is there any way to send looking like the original excel?

Thanks,

jcs

right click the worksheet tab
click the box Copy
save it in a new workbook
mail the new workbook

"Craig" wrote:

I often need to email a single worksheet within a workbook that has multiple
worksheets (tabs). When I do it by the icon Email, Send the current sheet as
the message body, it sends it out with no formating and is not in an excel
worksheet form. Is there any way to send looking like the original excel?

Thanks,

jcs

Hi Graig

Maybe changing your mail format in Outlook will help
ToolsOptions..Mail Format

Change to Html

Another way is to use code
See
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Craig" wrote in message ...
I often need to email a single worksheet within a workbook that has multiple worksheets (tabs). When I do it by the icon Email,
Send the current sheet as the message body, it sends it out with no formating and is not in an excel worksheet form. Is there any
way to send looking like the original excel?

Thanks,

jcs