Mail one sheet from Excel without using a new workbook
 

See also
http://www.rondebruin.nl/sendmail.htm

If you not use Outlook see the CDO link



--

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


"PhilM" wrote in message oups.com...
I need the code to automate the sending of a single sheet in the
message body of an Outlook email. The same as if I had pressed the
email icon in excel and selection send this sheet only

please help