Copy and Paste a Worksheet Range to Email Body

[Guest]

I am trying to figure out how to code a command button that will copy a range from a worksheet and open outlook then paste the range in the body of an email and send it to mail recipients using vba. Can anyone give me a hint on how to get started with this?

 

[Kieran]

Look at the comprehensive solutions in
http://www.rondebruin.nl/sendmail.htm.

I am sure your questions (and more) are anwered there.