View Single Post
 
Old 01-07-2012, 06:39 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote