Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2021, 12:40 PM
bwosk bwosk is offline Mail Merged Documents not updating file path when sent out to users Windows 10 Mail Merged Documents not updating file path when sent out to users Office 2016
Novice
Mail Merged Documents not updating file path when sent out to users
 
Join Date: Sep 2021
Posts: 3
bwosk is on a distinguished road
Default Mail Merged Documents not updating file path when sent out to users

Hello,



I've created an excel file acting as the main form that connects to word templates and automatically populates mail merged fields with values from an excel table. Users are able to fill out the excel form and open these word templates, connect via mail merge and populate needed fields in the template.

The issue I'm having is when the files are sent out, the file location of the data source doesn't update. I've had users save all relevant files locally, but the updated file location doesn't seem to connect to the excel file (even though it shows the correct path location from their local computer). Is there some kind of work around I can implement, or some way for users to update this data source location to have it actually connect to the main document?
Reply With Quote
  #2  
Old 09-19-2021, 04:47 PM
Guessed's Avatar
Guessed Guessed is online now Mail Merged Documents not updating file path when sent out to users Windows 10 Mail Merged Documents not updating file path when sent out to users Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,648
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

Can you post a sample doc/workbook? Are you saying the Excel file exists only in one place or a copy of both Word and Excel files go together onto the users machines?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 09-21-2021, 08:03 AM
bwosk bwosk is offline Mail Merged Documents not updating file path when sent out to users Windows 10 Mail Merged Documents not updating file path when sent out to users Office 2016
Novice
Mail Merged Documents not updating file path when sent out to users
 
Join Date: Sep 2021
Posts: 3
bwosk is on a distinguished road
Default Resolved

Thank you for your response, but by sheer luck it seems I've figured my issue out. It was as simple as disconnecting the data source from the mail merge main documents before sending them out and having users connect to data source on their own, ultimately saving the file and data source on their local paths.

Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merged Documents not updating file path when sent out to users Splitting merged Word document into individual .pdf documents (naming from a field in the file) ScarlettNZ Mail Merge 1 05-30-2019 12:53 AM
Mail Merged Documents not updating file path when sent out to users Mail Merge with Merged File Name in Footer DM2 Word VBA 10 05-01-2019 03:18 PM
Mail Merged Documents not updating file path when sent out to users Putting path and file name into all Word documents Kevin Beach Word 3 11-26-2016 06:14 PM
Mail Merged Documents not updating file path when sent out to users How to staple mail merged documents jopegk Mail Merge 10 06-12-2014 05:21 AM
Auto-updating smaller documents in a larger word file nmawells Word 0 05-27-2010 07:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:40 PM.


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