Set document properties word 2013
I moved all my files to a new computer, resulting in a new data path for the Excel file the Word mail merge doc is linking to. setting the mail merge mainĭocument type to Normal Word Document in the mailings tab. Typically clicking Yes in the SQL dialog box should disconnect the old data source, but I would at least "make sure" by e.g. The problem, but in fact Word "reverts" to the previous source the next time you open. 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 That will happen if the previous data source has not been properly disconnected - e.g. If no, the wrong data source is "sticking". Does that file exist? Is it the one you expect? If yes, again, I would suspect the Excel file. When you see the SQL warning and click Yes, do you then see a dialog box which provides the workbook path/name.
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.ģ. That may show that the file is/was at fault.Ģ. 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,