Code to send mail copying from Excel to a new outlook mail.

Thank you for your help but I probably dont get it. From what i can see your code doesnt take out the spaces in outlook either.

I used your code to send a mail to myself but i deleted some of the "test" rows. And it still got sent like this in the email.
spaces.png

I dont want any spaces. I want it to skip those cells that are empty..

Also if I only have test written out on A1 to I5, it still copies the empty cells from I20 into the mail. So you get alot of spaces in the mail.

Im sry. But that code doesnt work either. It feels like that code is kinda overboard of what i need?

I will upload the excel file that im working on. I probably dont understand, as i said im new to code, and maybe im not good at explaining whats wrong but my codes range is A1:G10. I have inserted some text in the first 3 rows. The rest is blank. When i press the "Mail" button in Sheet2 (named Uttag) all the empty cells copies over to the mail too. I want the code to only copy cells which has something written in it.

This is how i get it now. The red marker is what i would like to avoid..
spaces2.png

Sry if im annoying. And i am very grateful for all the help.

Here is the workbook..Lager test3.xlsm

I solved it kinda myself. in my code i added the Search and mark->Go to special->Constant and then i copied. Then when it paste in to the outlook mail only Constants will be pasted.

This is the code i used.

Please Login or Register  to view this content.

spaces3.png

The only issue is that if any cells between A1:F111 is empty then i get "Command cant copy multiple rows". Any way around that?