Roy, have a look here

http://www.rondebruin.nl/sendmail.htm#Tips

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Roy Harrill" wrote in message
...
I would appreciate knowing how to email the contents of a named range as
email text, so the recipients see the text directly right when they open
the email message, i.e., NOT an attachment. VBA's SendMail and Route
methods send the entire workbook object, but I don't want to send the
workbook. Can this be done?
Roy