Correct a Migrated or Missing SQL Mail Merge File in Word 2007
When you move a mail merged file and it’s list to a different folder or computer, the links don’t dynamically change. But the solution is easy enough.
When the message requesting to open the SQL command pops up, select No. If you selected Yes and the response was an error locating the file, exit and reopen, this time selecting No. It will circumnavigate many wasted clicks.
Navigate to the Mailings tab at the top and select Select Recipients from the Start Mail Merge section. Select Use Existing List… and locate your list. Save. When you open this document, you will now be able to select Yes to the SQL request as your normally would, unfettered again.