Sending a mail NOT as an attachment.

[BenNV]

I'm am able to send a mail as an attachment by using:

ActiveWorkbook.sendMail Recipients:="123@abc.com"

Is there a way to send the Excel sheet within the mail, like a copy and paste?

 

[crimlet]

Yes as you said, copy the selected cells open up a new mail message and paste

 

[BenNV]

Trying to find the lazy way round this! What I want to do is find some code that will allow this.

 

[eddy]

I need to do the same thing. It sounds simple but a simple cut'n'past dosn,t work. You loose the formatting. I would also like to see a solution using a macro if anyone knows how to do it.
eD