Sending mail with range as body using GMAIL

Dear,

normally i am able to send mail using gmail with example text by typing in body field.
but i want to send Range(A8:D17) as message body.
first i defined body1 as variable range, then i set body1 as value of my required range
in body of message i used variable 'body1' but it is giving error "run-time error '13' , Type mismached "

pls find the code as below...i which i am using and found by goggling...

Please Login or Register  to view this content.

pls suggest me where i need to change in ordger to send mail using range as body

Hi.. This works...

Please Login or Register  to view this content.

Note: If your range does NOT contain contiguous values.. then just copy the range to another sheet and then reset the range to that new block of data..