I will state here that I have no problem copying and pasting a range of cells
only into an Outlook email body but maybe an alternate method..............?
Try selecting the range of cells then SHIFT + Edit>Copy as Picture/.
Paste into the email body.
The "snapshot" icon would be the Camera Icon found under
Tools>Customize>Commands>Tools but that creates a dynamic and interactive copy.
Gord Dibben MS Excel MVP