mail an excel range in mail body

So I have this code which should mail from a sheet range A1:M42.
However the code still sends the active sheet in whole.

Can anybody give me some pointers why?
(the code says that if you only select 1 cell it will send whole sheet but I'm think I do select a range A1:M42)

Please Login or Register  to view this content.

.
Try this macro:

Please Login or Register  to view this content.

Thanks for this Logit.
Works nicely.

However does that mean my own code was not correct?
Actually I would like to know whats wrong with it.
Especially because it is working just not taking the range I want it to take.

.
If you DIM a few variables (see changes at top of macro), the macro works. However, it sends the entire sheet (all 1,048,000) rows. I might have miscalculated but I didn't think
your intention was to send the ENTIRE sheet as an email .... only the data entered on the sheet.

When you try this macro version, save the workbook first as an .xlsm (macro enabled workbook). Otherwise, you may lose the entire workbook when the email is sent.

Please Login or Register  to view this content.

Quickly put this in a test book.
But it actually does the same it already did.
Made the range all 1's and 2'on the outside.

Now after executing the macro it puts a selection around all the 1's but also mails the 2's and the button used to run the macro....
Attached the workbook so you can see.

.
My error.

I had not tested your macro. Now that I have ... I understand it sends only the data on the sheet, not the entire sheet.
The display just before sending led me to believe it was sending the entire worksheet.

You are correct it also sends the command button plus it attaches an image file of the command button to the email, 511 kb in size.

I should have fully tested it before commenting. Again, my apologies.

Yes but the button is outside of the range (A1:M42) en all the 2's in my attached workbook are also all out of the range.

So I still think it takes the full sheet.
But real question is why it does not take the range.
I would think this part in the code would do the trick:

Please Login or Register  to view this content.

.
I've looked around the Net and cannot locate anything (yet) that explains why MailEnvelope is designed to do, what it does.

Perhaps someone else has an explanation.

Ok thanks Logit.
Think I just will incorporate your solution.
Just wanted a way to mail a selection from an excel sheet into the mail body.
MailEnvelop was no necessity.

Ok, found it....

So here is were the problem was :

Please Login or Register  to view this content.

It should be this :

Please Login or Register  to view this content.

So aparently you should break this into 2 parts. Make the selection and then define that as the sendrange.