How to have a Hyperlink Mailto with more than 255 characters.

[Mark53]

Hello, people,

Wow. This forum sure makes it difficult to show a sample spreadsheet.
And I've read posts complaining, but that rule apparently ain't gonna' change. Ah, well. OK.

I've done a lengthy search, found many people with the same problem, but no answers.
How, in Excel 2007, to have a Hyperlink Mailto with more than 255 characters.
Looked at Ron de Bruin's RDBMail and SendMail add-ins, but they work only with MS Outlook.
I'm using Mozilla's Thunderbird.
When the total email is longer than 255 characters, Excel says #VALUE !
Cell A2 is =HYPERLINK("mailto:"&B2&"?Subject="&C2&"&Body="&D2&E2,"Click here")
Cell A3 is =HYPERLINK("mailto:"&B3&"?Subject="&C3&"&Body="&D3&E3,"Click here")
Cell A5 is =HYPERLINK(CONCATENATE("mailto:",B2,"?subject=",C2,"&body=",D2,E2),"Click here")
Cell A6 is =HYPERLINK(CONCATENATE("mailto:",B3,"?subject=",C3,"&body=",D3,E3),"Click here")

I simply want to Click on the cell, and it will open up a new outgoing email.

Any help would be Greatly appreciated.
Mark53

[TABLE="width: 398"]
<tbody>[TR]
[TD]Mailto[/TD]
[TD]to[/TD]
[TD]subject[/TD]
[TD]intro[/TD]
[TD]body[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Click here[/TD]
[TD]Joe@bla.com[/TD]
[TD]Details[/TD]
[TD]Hello,%0D%0A%0D%0AHere is some introductory text.%0D%0ANow, here comes the actual body of the email:%0D%0A%0D%0A[/TD]
[TD]This could be a lot of text.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]#VALUE ![/TD]
[TD]Sam@bla.com[/TD]
[TD]Details[/TD]
[TD]Hello,%0D%0A%0D%0AHere is some introductory text.%0D%0AThis is on a new line.%0D%0AAnd another new line of introductory text.%0D%0AAnd another new line of introductory text.%0D%0AAnd another new line of introductory text.%0D%0AAnd another new line of introductory text.%0D%0ANow, here comes the actual body of the email:%0D%0A%0D%0A[/TD]
[TD]This could be a lot of text. This is a test with more than 255 characters. This is a test with more than 255 characters. This is a test with more than 255 characters. This is a test with more than 255 characters. This is a test with more than 255 characters. This is a test with more than 255 characters. This is a test with more than 255 characters. This cell now has about 398 characters.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Click here[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]#VALUE ![/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Mark53]

Edit: I really don't care at all about the friendly "Click here" text.
I just want to click on the one cell, whatever it looks like, and make it work.
Ideas?

 

[SpillerBD]

The length of the hyperlink text is limited. If it was strictly text, you'd be alright (in a current version of Excel.)

 

[Fluff]

@Mark53

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all other sites where you have asked this question.

 

[Mark53]

Mea culpa, mea culpa, mea maxima culpa.
I apparently did something called cross-posting, and I sincerely apologize.
I did not realize that it was uncool, but the linked explanation makes that pretty clear.
And understandable. I shan't do it again.
A solution to this 255-character-max problem is revealed at
https://www.msofficeforums.com/excel/43262-how-have-hyperlink-mailto-more-255-characters.html
It works. Enjoy.
My humble Thanks to this forum, for the time and effort spent.
Mark53