How to always link source data (.xlsx) to same directory as Mailmergefile?

beefcake2000 · #1 01-23-2018, 07:43 AM

You are, of course, entirely right. The only thing is that I am making a template that will be used by different people by different purposes. I would like them to be able to move the mailmergedocument and Excel source data to different folders without them having to reselect (remerge) the source file.

macropod · #2 01-23-2018, 10:50 AM

Quote:

Originally Posted by beefcake2000

I would like them to be able to move the mailmergedocument and Excel source data to different folders without them having to reselect (remerge) the source file.

That isn't going to happen. How would Word ever know where it should look for the data source?

beefcake2000 · #3 01-24-2018, 02:07 AM

I realize that, Paul

That's why my initial question was whether it might be possible to hard code the data source (which always has the same name) in the Mailmerge Word file itself so that it always looks for this datasource in the same directory the Mailmerge Wordfile is opened from? I really appreciate the help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unlink source files when creating Church Directory with INCLUDEPICTURE	JohnFinNC	Mail Merge	3	09-18-2014 08:50 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM
How to dynamically link imbedded Excel chart with source data from Word	TBoz	Excel	1	07-06-2012 05:53 PM
Link and Keep Source Formatting--not exact	minny	Excel	2	04-09-2012 04:19 PM
Link and change source for multiple tabs from excel to powerpoint	excel3	PowerPoint	1	01-19-2012 02:01 AM