Sending Outlook E-mails with VBA and Copy / Pasting a range into the body of the e-mail

Hello,

I'm trying to send an e-mail with VBA. Nothing complicated so far. I found a code that allows me to "Paste" a selection into the e-mail I want to send.

Please Login or Register  to view this content.

The only problem with this is that it creates the e-mail on my Excel Worksheet. I can then press send to send the e-mail.

What I would like to do is the same thing but openning an E-mail in Outlook.
You know what I mean? By calling:
CreateObject("Outlook.Application") and OutMail = OutApp.CreateItem(0)
The code to send open an E-mail with outlook is this one (it also adds the workbook as an attachement).

Please Login or Register  to view this content.

So I guess I need something in between. I would like to be able to copy/paste a Range in my active sheet (like in the first code) in a new e-mail message that pops up from Outlook (like in the second code).
Were my explanation clear enough?

Thanks a lot for your help!!

Hi Jeffy14
Please insert Code Tags around your code then see this link
http://www.rondebruin.nl/mail/folder2/mail4.htm

Hi Jeffy14

I sent you the wrong link...try this...if you need help adapting let me know.
http://www.rondebruin.nl/mail/folder3/mail4.htm

Glad it works for you.

Ron also has an add-in to do the trick, but his site seems to be down for the moment