I'm trying to create a set of labels in a Word document that pull data from an Excel sheet. I've selected the data in the Excel sheet and made it into a table, which I called "zatDatabase". The table is in a sheet called "zatSheet".
When I try to mail merge when the Excel document is closed, my only choice for a table in the sheet is:
_xlnm#Print_Titles
When I try to mail merge when the Excel document is open, my only choice for a table in the sheet is:
zatSheet$Print_Titles
In both cases, the Description, Modified, and Created fields are blank and the Mail Merge Recipients is blank -- I cannot select any recipients from the Excel document.
I did have the Office 2010 beta installed for a time -- when I installed it I choose not to uninstall Office 2007. I have now uninstalled Office 2010 and am using Office 2007 again. Could this be the problem?
Other than leaving the Excel document open and changing the data in it from a normal range to a table, what else am I missing, what should I do to get this mail merge to work?
Bookmarks