I have an Excel spreadsheet in which I have a "named table." That is, I went to the Insert tab and used the "Insert Table" button to create an official table that Excel recognizes as such. I gave the table the name "AddressTble." I can see "AddressTble" in the Name drop down, and if I select the name the entire table highlights as it should. Everything looks normal.
However, when I go into Word to mailmerge from this spreadsheet and I select the spreadsheet as my data source, it pops up a list of tables with about table EXCEPT AddressTble. For instance, I see several variations of Sheet1$ such as "Sheet1$_xlnm#Print_Area, etc., as well as the other two tab names.
Why would I not see AddressTble? Is there a trick to making a table accessible to a Word mail merge?