See my SendMail page Gary
http://www.rondebruin.nl/sendmail.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Gary_Mc" wrote in message ...
When I attempt to email just 1 sheet I get an error that Excel can't open my
email program. If I select the whole workbook, my profile opens and waits
for the okay and the whole book ends up as an attachment. But, I don't want
the whole book. I just want to send one tab/sheet from the workbook
containing about 6 tabs/sheets total.