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

Atishay · #3 05-13-2024, 10:53 PM

Quote:

Originally Posted by NoSparks

You can't get around the 255 character limit of the hyperlink,
but you can change your approach and use the Worksheet_Followhyperlink event to call a macro that will shell out to Thunderbird.

I put some email addresses on rows 10 to 30 and copied your existing other stuff.
Ran the AddHyperlink sub to put in the hyperlinks.
Use the Worksheet_Followhyperlink event to get the row for the info and to call the SendEmail macro.

Code to shell to Thunderbird found here:
How can I automatically send email from Thunderbird with Excel VBA? - Stack Overflow

Hyperlink to run macro found here:
Link Hyperlink to Excel Macro — Excel Dashboards VBA and more

Doc to add hyperlink using code found here:
Hyperlinks.Add method (Excel) | Microsoft Docs

Hope this helps.

Hey NoSparks, I have the same issue of 255 characters in Hyperlink formula with mailto. The difference is that I need to use it in Outlook. So can you tell me how I can find a similar workaround?
I do have a basic understanding of the VBA too

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stop Word from displaying {HYPERLINK "mailto:my_email@provider.com"} in Print Layout View	Stargehzer	Word	2	11-17-2018 07:07 PM
Strange Characters appear when selecting SHOW ALL NON PRINTING CHARACTERS	ann Amber	Word	1	08-01-2015 08:06 PM
mailto Hyperlink in MailMerge	robpgreer	Mail Merge	3	05-06-2011 04:27 PM
Decoding mailto subjects	smaslin	Outlook	0	03-09-2009 08:09 AM
mailto in word	cinvernizzi	Word	0	02-17-2009 03:03 PM