+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    09-28-2010
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    86

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

    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:
    Please Login or Register  to view this content.
    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
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

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

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

  3. #3
    Registered User
    Join Date
    09-28-2010
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    86

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mailto Exceeding 255 Characters
    By Kapi187 in forum Excel General
    Replies: 1
    Last Post: 02-01-2013, 01:33 AM
  2. [SOLVED] mailto problem - too many characters gives #VALUE error
    By lplaforest in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 02:34 AM
  3. [SOLVED] mailto problem - too many characters gives me #VALUE error
    By lplaforest in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 10:29 PM
  4. MAILTO hyperlink email issue
    By Nans434 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-25-2012, 01:00 PM
  5. mailto hyperlink within button?
    By jamer02 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2011, 07:46 AM
  6. mailto hyperlink within button?
    By jamer02 in forum Excel General
    Replies: 0
    Last Post: 06-28-2011, 06:09 AM
  7. Zeilenumbruch in mailto:-Hyperlink
    By loriot in forum Excel General
    Replies: 1
    Last Post: 10-18-2005, 11:05 AM
  8. =hyperlink() for mailto:
    By README in forum Excel General
    Replies: 2
    Last Post: 02-25-2005, 11:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1