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?
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."
0
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?
0
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy 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
0
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.
0
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.
0
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).
0

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!
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.