When I click no and then go to Mailing, Select Recipients......I have 3 choices: type new list, use existing list, or select from outlook contacts

I choose use existing list.....navigate to the excel file on the new server but there is no data. If I click yes and enter in the path manually of the excel file on the new server then the data comes up correctly.

Get to the point where your mail merge main document is open. Then disconnect the data source (e.g., in Word 2007/2010, click the Mailings tab, Start Mail Merge, and click the Normal Word Document option). Then go through the connection process again, ideally ensuring that your merge type (labels/directory/whatever) and the merge destination are correct. Then save and close your document. Then re

I am having the same problem with some, but not all, Excel merge data sources for Word mail merge. There are two symptoms: (1)the data source will not stick as the recipient list and has to be search for every time or (2) the data source string is: " SELECT * FROM `Sheet1$` ", which does not find the file, of course.

I have tried the recommended "Say No to the SQL command box, reseek, and save mail merge master". This just ends up with no connection at all. When an existing merge document begins to behave this way it occurs on all versions of Word we have (2003, 2007, 2010).

1. Do you have the same problem if you try to connect a completely new Word document to the data source? If so, probably something wrong with the Excel file - if you can reconstruct it, or even create a test file with the same sheet name and column names, that may show that the file is/was at fault.

2. For the default OLE DB connection type, the SQL message is the correct one - the SQL does not reference the workbook path or name - that comes from the file name or connection string which is not displayed in that dialog box.

3. When you see the SQL warning and click Yes, do you then see a dialog box which provides the workbook path/name. Does that file exist? Is it the one you expect? If yes, again, I would suspect the Excel file. If no, the wrong data source is "sticking". That will happen if the previous data source has not been properly disconnected - e.g. If you proceed from the dialog I mention, then choose the option to find the data source in the next or subsequent dialog, it does then appear that you have corrected the problem, but in fact Word "reverts" to the previous source the next time you open. Typically clicking Yes in the SQL dialog box should disconnect the old data source, but I would at least "make sure" by e.g. setting the mail merge main document type to Normal Word Document in the mailings

Found this response in a search, as I was experiencing the same issue...

Worked like a charm!

THANKS!

This should work:

• change the file-extension of your main document from .docx to .zip
• unzip the file
• open the file "word\settings\settings.xml" in notepad
• change the values for the DataSource (twice)
• save the file
• repeat for "word\_rels\settings.xml.rels"
• rezip the files
• change the file-extension back to docx

Tedious, but there are some tools available that do search/replace inside zipfiles

--

Cheers!