When merging an excel spreadsheet with a word doc, I am asked to confirm data source in a window that shows several ".xls sources". I've tried cliking on each one, but each one states "word was unable to open data source". As long as I've been doing mail merges, I have never seen this window before???
Make sure you have closed the "data source" your excel file before trying to merge. This has been throwing different errors but not allowing the merge process to continue.
Is your Excel data in various worksheets or in the same worksheet - And does your Excel source data contain headers in the first row. Once you have selected this from the range you will
At what stage are you failing in the merge now?
Was this helpful?
Yes
No
Popular Solutions for Microsoft Office Professional
Suddenly I am denied all aspects of creating a new publisher document and Restore doesnt fix...
(More)
Suddenly I am denied all aspects of creating a new publisher document and Restore doesnt fix problem. Microsoft will not accept the Product Key that I have.
when I try to use mail merge in 2007, and complete the merge, it only pulls in the first three and...
(More)
when I try to use mail merge in 2007, and complete the merge, it only pulls in the first three and last three records form my chosen database file. All files are the same so I believe that it is not the database and that it is the template doc in word. can you advise.. I did try to repair word 2007 by re-installing, but that did not work... possibly I have a conflict with another program installed....