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

Mark53

New Member
Joined
Jan 9, 2011
Messages
9
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

Mailtotosubjectintrobody
Click hereJoe@bla.comDetailsHello,%0D%0A%0D%0AHere is some introductory text.%0D%0ANow, here comes the actual body of the email:%0D%0A%0D%0AThis could be a lot of text.
#VALUE !Sam@bla.comDetailsHello,%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%0AThis 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.
Click here
#VALUE !

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Mark53

New Member
Joined
Jan 9, 2011
Messages
9
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

Well-known Member
Joined
Jul 2, 2014
Messages
2,707
The length of the hyperlink text is limited. If it was strictly text, you'd be alright (in a current version of Excel.)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,533
Office Version
  1. 365
Platform
  1. Windows
@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

New Member
Joined
Jan 9, 2011
Messages
9
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,655
Messages
5,549,254
Members
410,905
Latest member
Extjel
Top