Believe Ron covers this:

Ron de Bruin
http://www.rondebruin.nl/sendmail.htm
http://msdn.microsoft.com/library/en...odc_xlmail.asp

Dick Kuselika
www.dicks-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm

--
Regards,
Tom Ogilvy



"Karen" wrote in message
...
Hi - can anyone tell me if it is possible to write a macro
that will select a worksheet (or part of a worksheet) and
paste the contents in an Outlook message. We don't want
an attachment, just the data. If it's possible, can you
tell me how to do it?
Thanks!