Microsoft Word SQL Command Error

Question

I have a Word Document that uses an Excel File for a data source for a mail merge.  I've moved the Excel file to a new folder and now I get the following message:

Opening this document will run the following SQL Command:

SELECT + FROM /xxx/xxxx.xllxs <<< old location

Data from your database will be placed in the document.  Do you want to continue?

When I click on Yes I get the following message:

Sorry, we couldn't find \xxx\xxx.xlxs.  Is it possible it was moved, renamed or deleted?  [OK]

Clicking OK will then open the file.

How do I change the path of the data source to the new location so I don't get the error message about the wrong path?

I using Word from Office 365.

Thank you.

Answer 1

Check below link. The last post has a possible solution for your problem

https://social.technet.microsoft.com/Forums/ie/...

Answer 2

I believe you need to recreate the Data Document as part of the mail merge. Or at least change the properties of the data document.