0

=HYPERLINK("mailto:" & TEXTJOIN(",", TRUE, M1:M32), "Email All") this formula is not working unless I make the range to "M1:M10" Why? Im trying to combine 32 email addresses into one hyperlink that would email all at once with one click and open Outlook.

Restarted excel. Tried a new blank document. Nothing worked.

Improve this question
2
  • 4
    You only get 255 characters in the link. Do you exceed that in the larger range? Do =LEN(TEXTJOIN(",", TRUE, M1:M32)) + LEN("mailto:") Commented Aug 29 at 18:34
  • 1
    The way around is to insert a hyperlink through vba in a worksheet change event. This will allow a longer hyperlink. Commented Aug 29 at 18:41
Related questions
1471
How to change the href attribute for a hyperlink using jQuery
0
MS Access VBA add email link to Excel sheet
2
Extract hyperlink in PDF to Excel
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.