I have just moved all my files to a new PC.

With identically named file locations my MailMerge in Word successfully links to an Excel workbook which contains the merge data.

I want however to move the Excel Workbook to a differently-named location (so that it is in the OneDrive directory).

When I do this I cannot re-link to the data source.

I can find the Workbook to link it, but when I select it I get the message "The Data Connection Wizard cannot obtain a list of databases from the specified source".

This happens whether or not the Workbook is open.

Curiously . . . I have kept copies of the MailMerge and the Workbook in their original locations - that connection still works. But if I try and connect the copy of the MailMerge in its new location with the Workbook in the old location I still get the error message. So it doesn't seem to the the location of the Workbook that is the issue.

I would be grateful for any help in how to reconnect my MailMerge to the Workbook source.

Martin

PS The copy of the MailMerge document in the new location remains successfully linked to the copy of the Workbook in the old location. I just cannot link it to the copy of the Workbook in the new location.