Cut and paste to Outlook using a macro

[Karen]

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!

 

[Tom Ogilvy]

Believe Ron covers this:

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

Dick Kuselika
www.dicks-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm