How to have a Hyperlink Mailto with more than 255 characters.
Results 1 to 5 of 5

Thread: How to have a Hyperlink Mailto with more than 255 characters.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2011
    Posts
    9
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

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

    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

    Mailto to subject intro body
    Click here Joe@bla.com Details Hello,%0D%0A%0D%0AHere is some introductory text.%0D%0ANow, here comes the actual body of the email:%0D%0A%0D%0A This could be a lot of text.
    #VALUE ! Sam@bla.com Details Hello,%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%0A This 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 !

  2. #2
    New Member
    Join Date
    Jan 2011
    Posts
    9
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

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

    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?

  3. #3
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    2,662
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

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

    The length of the hyperlink text is limited. If it was strictly text, you'd be alright (in a current version of Excel.)
    Excel 2013, 2016 with PowerBI
    Knowing that it can be done is half the battle!

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,841
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

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

    @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.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #5
    New Member
    Join Date
    Jan 2011
    Posts
    9
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

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

    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...haracters.html
    It works. Enjoy.
    My humble Thanks to this forum, for the time and effort spent.
    Mark53

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •