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!
Found a VBA script that allegedly works, but I cannot even figure out how to install the durn thing.
That fact alone angers me. I've been working with computers for 45 years. Not a beginner!
Searched for "how to install an excel vba script" and read all of:
https://www.thespreadsheetguru.com/b...crosoft-office
https://spreadsheeto.com/vba-editor/
https://itstillworks.com/create-ms-e...t-5873156.html
https://www.ablebits.com/office-addi...a-macro-excel/
https://www.guru99.com/creating-your...-in-excel.html
https://smallbusiness.chron.com/crea...ipt-41089.html
Still, cannot determine how to get the script to do anything. Should be easy, me thinks.
The VBA script that Might work (but I cannot install it) looks like:
I do not want the extra hassle of going thru Developer > Macros > select it > Run.
I simply want to Click on the cell, and it will open up a new outgoing email.
Thus, maybe VBA is Not the solution?
Any help would be Greatly appreciated.
Mark53
Bookmarks