Emailing worksheet

[Craig]

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

 

[Guest]

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

 

[Ron de Bruin]

Hi Graig

Maybe changing your mail format in Outlook will help
Tools>Options..Mail Format

Change to Html

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