Hello, people,

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.
Attached is a sample spreadsheet with my attempts, with or without the Concatenate function.
When the email is longer than 255 characters, Excel says #VALUE!

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

Any help would be Greatly appreciated.
Mark2438

Attached Files

excel email over 255 13.xlsx (8.7 KB, 211 views)