Cannot find mail merge data source.

Anonymous
2022-02-15T22:12:00+00:00

I have a an old mail merge Word document that has been moved to a new computer and a changed drive. My problem is I don't know the name of the Excel data source. Is there any way to see what file the Word merge is looking for? Actually using Word 2019.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Suzanne S Barnhill 278.3K Reputation points MVP Volunteer Moderator
    2022-02-16T12:52:43+00:00

    If you have some idea of the content of the Excel file, you could search your Excel documents (using File Explorer) for some text snippet that would appear in it.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-02-16T04:52:25+00:00

    Thanks Doug,

    Looks like I am in out of luck category.

    Was this answer helpful?

    0 comments
  3. Doug Robbins - MVP - Office Apps and Services 323.3K Reputation points MVP Volunteer Moderator
    2022-02-16T02:05:16+00:00

    If the document was saved with the data source attached to it, when you open the document and click on Yes in the SQL warning message that appears, if the data source is no longer accessible, you should see an error message that contains the name of the original data source

    If the SQL warning message does not appear, you are out of luck.

    Was this answer helpful?

    0 comments