Hi,



I have used a specific file the last 4 months for my mail merge. All of a sudden it stopped working... ??? I didn't do anything different that I have before. When I try to import the data into mail merge, none of my tables show up (see attachment). Then, when I select "ok", it tells me that Word is unable to open the data source.

Any suggestions???

Thanks!

Attached Images

2014-03-14 13_56_08-Document1 - Microsoft Word.jpg (16.2 KB, 42 views)

I note your profile says you're using Office 2010, but the error message refers to an .xls format worksheet, which is the older format. Are you sure your workbook is still in the .xls format and hasn't been changed to the newer .xlsx format?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

You're right. The error message refers to an .xls format, but the document is in and .xlsx format. What do I need to do to fix it and why did that change?
Here are the document properties:

Attached Images

2014-03-14 14_30_41-Microsoft Excel - Mail Merge.jpg (32.8 KB, 41 views)

Simply select the correct file as the data source, save the updated file, then continue as before. For example (assuming you're still getting the SQL prompt upon opening the document), when the 'Data Link Properties' dialogue pops up, simply add the missing 'x' to the end of the file extension.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks, but I already tried that - it won't let me edit the file extension. Any other suggestions?

The 'Connections' panel on that dialogue allow you to change the entire file path & name, if need be - but the change won't be saved. For a permanent update, simply answer 'No' to the initial SQL prompt when you open the document, then use 'Select Recipients' on the Mailings tab to navigate to and select the correct workbook.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The exact same thing happened to me!! I figured what was wrong. May be your issue as well:
Check your other sheets in your document. One of the other sheets was hi-lighted to be copied and it was saved that way by mistake. Once I un-highlighted the cell on the other sheet, my mail merge went through perfectly.