Limit Word Mailmerge Data to an Excel Named Table

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?Select Table Dialog
witzph1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

witzph1Author Commented:
Sorry, I meant to say "...it pops up a list of tables with about every table name EXCEPT AddressTble."
Katie PierceCommented:
In your spreadsheet, when you select the dropdown in the Name Box in the top left of the sheet, can you confirm that AddressTble appears?
GrahamSkanRetiredCommented:
Can you redact your workbbok so that there is no identifiable confidential data? If so, and if the problem is still there, post the workbook, so that it can be tested on other systems.

If it does fail elsewhere, we can try to fix the problem.

If it doesn't we might be able to suggest things such as 'Office repair' for you to try.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

witzph1Author Commented:
Very odd.  I wrote a reply, attached the file and I thought clicked "submit."  It's not showing up.  I'm trying again.  Sorry if it posts twice.  

Katie, yes the named table appears in the Name drop down.
Mailing-List.xlsx
Katie PierceCommented:
Your list is the one ending in FilterDatabase because you have filters set on the table. Try selecting it in the Mail Merge and see if it gives you the result you're hoping for. Or, clear the filters in the table & use the whole data set.
witzph1Author Commented:
Katie, yes, FilterDatabase seems to give me the right table.  I guess I should have tried that.  

But I would not expect a filter to interfere with the underlying named table in a Word mail merge.  I did try removing the filter and then re-connecting the mail merge document with the spreadsheet.  The named range still does not show the named range.  

It seems like a named range should always be an option.
Katie PierceCommented:
I agree, it's bizarre. I did a quick Google search on "sheet1$_xlnm#_filterdatabase" and that seems to be a default naming scheme in Excel for internally created data sets that are accessed from outside of Excel (as in Word mail merge).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
witzph1Author Commented:
Thanks for your help, Katie!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.