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!

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!