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>
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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?
 
Upvote 0
The length of the hyperlink text is limited. If it was strictly text, you'd be alright (in a current version of Excel.)
 
Upvote 0
@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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top