Hi navysalad,
Quote:
|
the only way I've found to make this work is to change the name of the master Excel file so that Word can't find it, then when I get the "file not found" error message, it lets me enter the name of the local Excel file.
|
As previously indicated, if you open your 'master' mailmerge main document and answer 'No' to the "Opening this document will run the following SQL command:" prompt, then save, you'll no longer have the mailmerge trying to attach itself to the wrong (or any) data source. From then on, you'll only need to attach a data source for the copies.
Quote:
|
Is there any way to just code the local file name (with no path) into the merge process?
|
No, that's not possible.