message in Word mail merge - cannot open data source

P

patgar

I have been using Excel as the data source for mail merge in Word with no
problems. I have two excel files. One works perfectly well but the other is
now coming up with "Word was unable to open the Data Source" Any
suggestions welcome
 
P

Peter Jamieson

Which version of Word/Excel?

If the "bad" workbook is simple enough (e.g. no formulas, just data, try
exporting the sheet(s) to .csv format and importing them into a completely
new workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Merging from an Excel file with graphics 1
Grouping Names in Mail Merge 0
Mail Merge query 1
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Mail Merge skipping records/sending one at a time 0
Mail Merge - displaying a conditional number of decimals 5
Mail Merging into PowerPoint 0

Top