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

    Question Conditional hyperlink depending on field

    Hello,
    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!

    Mdumont

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 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.
    Cheers,

    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
  •