+ Reply to Thread
Results 1 to 3 of 3

Hyperlink issues

  1. #1
    Registered User
    Join Date
    02-03-2022
    Location
    Des Moines
    MS-Off Ver
    Offive 365
    Posts
    2

    Hyperlink issues

    In my worksheet I use a Hyperlink to speed up my emailing process. In the following formula, everything works, until F2 becomes longer than 17 characters. Example F2="ID 12345678 Chris" works, but when F2="ID 12345678 Chris H" i get #value errors. Below is my formula

    =HYPERLINK("mailto:"&Sheet1!A1&"?"&"cc="&Sheet1!E1&"&subject="&'INV List'!F2&"&body="&'INV List'!E1&"%0d%0a"&"I have assigned "&F2&" "&"to you for review."&"%0d%0a"&"Please let me know within 48 business hours if able to Rx or send to OAH.","Send Email")

    ANY advice would be GREATLY appreciated

    Chris

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Hyperlink issues

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-03-2022
    Location
    Des Moines
    MS-Off Ver
    Offive 365
    Posts
    2

    Re: Hyperlink issues

    I have uploaded the workbook INV5 Beta.

    Thanks
    Chris
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 05-10-2021, 11:21 AM
  2. Issues with Hyperlink and INDIRECT
    By BSGUK in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-17-2018, 06:45 AM
  3. hyperlink issues
    By pgalligan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2018, 09:34 PM
  4. Replies: 3
    Last Post: 07-16-2014, 01:50 AM
  5. Hyperlink Issues going to hidden sheets
    By Thelt2000x in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2011, 01:45 PM
  6. Macro Hyperlink issues
    By murphybrendan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2008, 01:06 PM
  7. PDF hyperlink issues
    By Jamie in forum Excel General
    Replies: 0
    Last Post: 06-29-2005, 08:05 AM

Tags for this Thread

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