Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2024, 10:11 AM
MarkT3676 MarkT3676 is offline URL as Mergefield does not save Windows 10 URL as Mergefield does not save Office 2021
Novice
URL as Mergefield does not save
 
Join Date: Mar 2024
Posts: 1
MarkT3676 is on a distinguished road
Default URL as Mergefield does not save

I have a Word document that mail merges from an Access database.
The word document includes a static text field which is clickable, with a URL tag behind it.
In Alt+F9 view, I have the following code:

{HYPERLINK {MERGEFIELD LINK_URL}}
where Link_URL is the merge field from the database query.

It works perfectly, but when I save the WORD document, the URL Mergefield is not saved. Instead the prior actual merged value is saved as below.



When I re-open the document, this is what shows in Alt+F9 view:
HYPERLINK "https://www.youtube.com/etc.etc.etc"
Where the hyperlink is the merged field value from the prior run.

How can I encode the hyperlink as merge field, so that it persists when I save the document?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
URL as Mergefield does not save IncludePicture with Mergefield paluccie Mail Merge 3 03-13-2021 06:34 AM
URL as Mergefield does not save Replace characters in mergefield tommatwalker Mail Merge 6 07-17-2018 12:30 AM
URL as Mergefield does not save Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
SUM a single mergefield kawirider88 Mail Merge 1 09-29-2013 06:37 PM
URL as Mergefield does not save Substituting a value using MERGEFIELD CharlieVW Mail Merge 3 05-07-2012 12:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 AM.


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