Update mail merge source in Word 2007
Posted on 2011-09-26
I recently moved from Windows XP to Win7, and simultaneously from Office XP to Office 2007. Because I've changed the Windows version, all my files are now in a different location, which breaks all of my mail merge documents (since the source location is a fully-qualified path, rather than relative).
When I open a mail merge document (.doc, FWIW), I get the error message that the source document (an Excel .xls spreadsheet) can't be found ("not a valid path," since the prior folder location no longer exists). I can specify the new location, and the merge works correctly. But it isn't saved; indeed, I get an error message asking for the source even while I'm saving the merge document, and then when I reopen, it starts all over again.
I don't want to remove the source from the mail merge document, because then I'll lose all the merge formatting, some of which is rather complex (If/Then, etc.). How can I get the updated source location to be saved permanently?