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?
|