Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2020, 05:22 AM
bgotchel bgotchel is offline Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Windows 7 64bit Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Office 2019
Novice
Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path
 
Join Date: May 2020
Posts: 3
bgotchel is on a distinguished road
Default Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path

Hi all,

I've been wrestling with Word for a while now trying to create a clickable hyperlink that varies depending on the value of a given field in the data source. This is for use in an email merge.

I've gotten as far as this:


Quote:
{ HYPERLINK {IF { MERGEFIELD }="" "google.com" "bing.com" {SET keepme1 1} }\* MERGEFORMAT }
What's happening at this point is that I switch the formatting back (Shift+F9) and the hover-text/URL becomes a modified, invalid local path that seems to merge my target URL with the location of my Word document. Here's an example:

Anyone have any suggestions for how to avoid this strange issue?

Thanks!

P.S. These are the steps/instructions I've followed thus far:
Basic hyperlink set-up: email mail merge in Office 2010 with hyperlinks | originaldougal
Setting bookmarks to prevent merge field erasure: Adding hyperlinks in a mail merge document from a Excel database - Microsoft Community
Reply With Quote
  #2  
Old 05-15-2020, 05:23 PM
macropod's Avatar
macropod macropod is offline Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Windows 7 64bit Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As clearly stated in the Mailmerge Hyperlink ‘Click Here’ Insertion topic in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/mail-...s-tricks.html) - which is one of the links your own references link back to:
Quote:
The above is only for merged output sent to a new document; it does not work with merges to email or print. For merges to email, see: https://support.microsoft.com/en-us/kb/912679
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-18-2020, 04:14 AM
bgotchel bgotchel is offline Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Windows 7 64bit Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Office 2019
Novice
Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path
 
Join Date: May 2020
Posts: 3
bgotchel is on a distinguished road
Default

Hi Paul,

Thanks for your response.

I did see that note in the Tips & Tricks topic, but I'm not sure how it applies here. The Microsoft support page it links to seems identical to the page I used, except that "originaldougal.com" seems to be geared towards more recent versions of Office.

And the issue I'm running into isn't that my "data source fields are converted to plain text," but that the underlying link is being changed from my desired URL (e.g., "www.bing.com") to a different, broken URL (e.g., "https://my.sharepoint.com/personal/Documents/www.bing.com"). I can't seem to find any guidance on this elsewhere.

I fully acknowledge that I may be missing something obvious that you're trying to point out - so just let me know if that's the case! Thanks for sharing your thoughts.

Cheers,
Benjamin
Reply With Quote
  #4  
Old 05-18-2020, 04:48 PM
macropod's Avatar
macropod macropod is offline Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Windows 7 64bit Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Given that your IF test omits the required 'http://' or 'https://' from each of the conditional outputs, Word assumes you're referring to a bookmark in the document itself.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-19-2020, 04:50 AM
bgotchel bgotchel is offline Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Windows 7 64bit Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Office 2019
Novice
Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path
 
Join Date: May 2020
Posts: 3
bgotchel is on a distinguished road
Default

Thanks for the follow-up, Paul!

I tested out the http:// addition and sure enough, that did the trick. Thanks for your help! Really appreciate it.
Reply With Quote
Reply

Tags
conditional, hyperlink, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink formula returning 'invalid site address' MarkH Excel 0 12-26-2015 10:43 AM
Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path excel 2013 local file contact to shared path when i open it osama6767 Excel 3 05-28-2014 06:29 AM
Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Inserting an Email Address with hyperlink into a Mail Merge Letter AClaborn Mail Merge 3 10-15-2013 04:02 PM
Mail Merge to Email - Conditional Hyperlink Getting Changed to Invalid Local Path Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Accidently changed the email's preview in the incoming mail omers66 Office 0 08-12-2010 01:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft