Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2015
    Thanked 0 Times in 0 Posts

    Question Conditional hyperlink depending on field

    I'd like to have a hyperlink appear (or disappear) based on the presence of a field. The field is the name of the product.
    In the end, I'd like the text to look like this:

    To access Product x, click here.

    I got the ''To access" part with an IF command to appear if the field Product X is filled in my excel database. However, when I try to apply an IF command to a Hyperlink field, it disables the link.

    Any idea how I could fix that?

    Thanks in advance!


  2. #2
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Canberra, Australian Capital Territory, Australia
    Thanked 470 Times in 387 Posts
    Working hyperlinks cannot be nested inside IF fields. You mention product data being supplied from an Excel database. If that's via a mailmerge and the hyperlink is included in the Excel file, the Mailmerge Tips & Tricks Sticky thread at the top of this forum has an item that shows how you can turn 'To access Product x, click here' into a clickable hyperlink as part of the mailmerge process.

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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