Ask a new question

Mail merge problems with Word 2013

We have recently upgraded to office 2013.  I am trying to use a word document and an excel spreadsheet that I have used many times before to mailmerge some letters.  I have followed exactly the same steps as always, but when I click on the select recipents and choose my excel file, a dialogue box saying "select table" comes up with random file names in it.  Has anyone any thoughts?  Thanks very much

Answer
Answer

If you are seeing "Select table" you are probably seeing the correct thing. Each "Table" is either a worksheet or a "named range" in the Excel workbook. The "worksheet" names should look the same as the names on the worksheet tabs in Excel.


Historically, Word has had several different ways to connect to Excel data, and it may be that your existing document used one of the older ones (typically DDE) which only worked with the first sheet in the workbook, so did not require you to select a worksheet or a "table".

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 1, 2021 Views 1 Applies to: