Can?t send long text from Excel via Outlook

Hi all,
I would like to send text from Excel via Outlook
It is 189 words and 1243 symbols with a small picture.
But I can not. I can send only a short text. This is my send string: =HYPERLINK("mailto:"&E38&"?subject=Test&body="&$B$53;"Senden")
Maybe somebody can help me, please and explain what I should do to send 189 words with small pics
Thanks in advance.

This is one of many methods.

The following allows you to edit this section of code, to specify what portion/s of the sheet range you want pasted into the email body:

Sheets("Sheet1").Range("Q2:Y4") = Sheets("Sheet1").Range("B18:F20").Value
Sheets("Sheet1").Range("Q7:V18") = Sheets("Sheet1").Range("B2:G13").Value

Sheets("Sheet1").Range("B2:G13").Copy
Sheets("Sheet1").Range("Q7:V18").PasteSpecial Paste:=xlPasteFormats

ENTIRE CODE :

Please Login or Register  to view this content.

Thanks a lot,
I will have a look.
For me it is Intrresting to know if it is possible to do this without programming?
Why it does not send it at my case.

If you want the email to auto send prior to reviewing .... change the following lines of code :

Please Login or Register  to view this content.

Comment out Display like this : '.Display

Then Uncomment Send like this : .Send

Thanks, a lot for your help. I think it is misunderstanding.
I open an Excel file, and I press at send at the excel cell( =HYPERLINK("mailto:"&E38&"?subject=Test&body="&$B$53;"Senden") ) and the outlook will be opened.
And after, I press at outlook send button.
It means two applications: 1 Excel and after is 2Outlook.
Maybe somebody knows what I have to correct to send longer text. Thanks
Attachment 809167Attachment 809168