+ Reply to Thread
Results 1 to 8 of 8

Help!! hyperlink Friendly name not working

Hybrid View

  1. #1
    Registered User
    Join Date
    01-07-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    4

    Help!! hyperlink Friendly name not working

    Hello guys,

    is there someone out there who could help me to put a friendly name in my email? because my formula does'nt work

    =HYPERLINK("mailto:"&VLOOKUP($A$1,Database!$B:$R,14,0))&"?subject=Permission Request", "Friendly Name")

    Hope someone will help me

    Thanks...

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Help!! hyperlink Friendly name not working

    hi Betobels ,

    can you upload a sample file with sufficient data to explain your problem.

    Punnam

  3. #3
    Registered User
    Join Date
    01-07-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    4

    Re: Help!! hyperlink Friendly name not working

    HiPunnam,

    Thank you for getting back on me. But i already figured it out. however i still have some queries regarding my formulas. I wish to link the email with the whole body content of the email. could you please help me with this see my attachment. Also can you teach me how to indent the specific text inside the cell.

    e.g. King Betobels to King Betobels without using the spacebar.

    Thank you.
    Attached Files Attached Files

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Help!! hyperlink Friendly name not working

    =HYPERLINK("mailto:"&VLOOKUP($A1,Database!A:K,8,FALSE)&"?subject=Permission Request", "Send Email") change
    as =HYPERLINK("mailto:"&VLOOKUP($A1,Database!A:K,11,FALSE)&"?subject=Permission Request", "Send Email")
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Help!! hyperlink Friendly name not working

    Hi Betobels,

    I should say thanks to you , i have used Hyperlink to link the file from different location but not to outlook.

    Punnam

  6. #6
    Registered User
    Join Date
    01-07-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    4

    Re: Help!! hyperlink Friendly name not working

    Hi Siva,

    Is there a possible way to link the e whole email content in outlook?

    Thanks

  7. #7
    Registered User
    Join Date
    01-07-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    4

    Re: Help!! hyperlink Friendly name not working

    Hi Siva,

    Is there a possible way to link the e whole email content in outlook?

    Thanks

  8. #8
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Help!! hyperlink Friendly name not working

    see the attached file
    =HYPERLINK("mailto:"&VLOOKUP($A1,Database!A:K,11,FALSE)&"?subject="&A6&"&Body="&A12, "Send Email")
    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. remove hyperlink but keep friendly name
    By DaveKimble in forum Excel General
    Replies: 4
    Last Post: 12-13-2011, 11:23 PM
  2. Friendly Names for Hyperlink Formula Macros
    By Rhettoric101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2011, 03:49 PM
  3. Hyperlink Friendly Name as File Icon.
    By Bluewhistler in forum Excel General
    Replies: 5
    Last Post: 02-10-2010, 05:13 AM
  4. Replies: 2
    Last Post: 03-31-2006, 12:15 AM
  5. [SOLVED] how to get hyperlink from the friendly name in xl.
    By jae in forum Excel General
    Replies: 1
    Last Post: 01-20-2006, 02:20 PM

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