Copy Range to Body of Outlook Message and Display

Pasting Cells themselves into an Outlook message is actually a lot more involved than you'd think. You can check out this link as a reference to get you started, but alternatively, if you didn't need the formatting you could probably just paste the values into the body fairly simply.

http://www.office-loesung.de/ftopic380280_0_0_asc.php

Here is the relevant code, again, taken from user Nepumuk over at office-loesung.de:

Please Login or Register  to view this content.

Not that I've seen. The issue is copying a range has to include HTML markup as the standard VBA method only uses text strings. Including anything other than text requires converting whatever you want to paste into HTML first, before including it in the body. Like I said, if you just want the values, then that's easier. It's the formatting that makes it tricky.

Something like this should get you close (untested):

Please Login or Register  to view this content.

Here is shorter version of sending a Range as HTML in the body of an email.

Send Range in Body of an Email

Please Login or Register  to view this content.

Example of Using the Macro

Please Login or Register  to view this content.