Thread: Word Mail Merge Document - Data Link Connection
View Single Post
 
Old 12-03-2023, 07:34 AM
shleppy shleppy is offline Windows 11 Office 2021
Novice
  
Join Date: Nov 2023
Posts: 4
shleppy is on a distinguished road
Default
Quote:
Originally Posted by Guessed View Post
  1. Make a copy of the Word document.
  2. Change the file extension of that document to .zip
  3. Open the zip file and go into the Word folder
  4. Copy the settings.xml file in that folder to a location outside of the zip file. Open it and search for the path to the old data source. Edit that path to point at the new location. There may be more than one instance so change them both. Save and close that edited file.
  5. Copy the updated settings.xml file back into the zip file to overwrite the version there. Save and close the zip.
  6. Change the file extension back to .docm and open it normally.

Perfect that worked for me for one set of documents. So I have 2 databases and db1 has already the correct database connection in the settings.xml. On the other set of word documents which point to db2 I updated the settings.xml and it worked but I do not understand why the same document which run and connect to db1 are not updating and still pulling the old data link connection.
Reply With Quote