How to get data from multiple sheets an in .xlw into mail merge
Posted on 2011-09-14
I have office 2003 and am trying to create a mail merge in publisher from excel.
The excel sheet is in .xlw opposed to .xls - there is no difference that my eye can see but I haven't really dug too deep.
When I try to mail merge into publisher, it's asking for a specific database type and won't accept the .xlw or any other format I am able to "Save as" from excel.
The excel workbook has multiple pages and I'd like to be able to pull from them independently, as online instructions say I can.
I was getting a verbose error message that after research, had me install a Microsoft database tool update, now I get a "cannot open data source" error
It seems like the mail merge tool only wants to open .dbx or odbx file types.
How can I get the data from this excel sheet into publisher?