copy range of cells from excel and paste them into email body

[Gaz1000]

Hello,

Does anyone know how I can copy a range of cells from an excel worksheet and then paste them into an outlook email body?

Although I was hoping not as text, because I would prefer not to be able to change the cell values once they are in the email.

 

[Gaz1000]

"Although I was hoping not as text, because I would prefer not to be able to change the cell values once they are in the email."

OK forget about that first bit - what about this bit?

"how I can copy a range of cells from an excel worksheet and then paste them into an outlook email body"

Worksheets(UserName).Activate
Range("B" & startrow & ":" & "C" & endrow).Select
Selection.Copy

I'm using this to copy the cells, now I just need to find out how to paste it into email body. Anyone???