Hi Pablo55

See this page for code examples to send as body and attachment
http://www.rondebruin.nl/sendmail.htm

Or do you want to send the activesheet in the body of the mail like you can
do in <2007

You can add this option to the QAT if you want
Read how on this page
http://www.rondebruin.nl/0307commands.htm

The name is "Send to Mail Recipient"
Search for it in the commands that are not in the ribbon list





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pablo55" wrote in message ...
how can I e mail a single worksheet in excel 2007