email as attachment

[k1]

i am using 2007 excel and i can email but i am looking for emailing a single
sheet.
i am unable to find this command. currently the email icon only shows that
it is emailing the entire book.

 

[Ron de Bruin]

Hi k1

You must add it to the QAT
http://www.rondebruin.nl/0307commands.htm

The name = "Send to Mail Recipient"

 

[k1]

thanks, but it will send as entire message body.
did not see option for just a sheet as attachment.
k1

 

[Ron de Bruin]

Sorry i not read it correct

If You want to send one sheet as attachment then you can use my Mail add-in
http://www.rondebruin.nl/mail/add-in.htm

Or copy the sheet to a new workbook and send that file
Right click on the sheet tab
Move or Copy
Choose To new workbook and check the "create copy" checkbox