Get Word 2016 Mail Merge Unable To Open Data Source Gif. The data for this document is a microsoft excel worksheet to work around this issue, use a.csv or.xls file instead of an.xlsx file as the data source. Word was unable to open data source.
I feel like i've tried everything. In word use tools/mail merge and then select query options. Mail merge is not just for documents;
The mail merge feature of microsoft word is one of my favorite parts of the program.
My question is why, and what do i do to get around it? When i attempt to use the datasource (file is located on a network drive), i get the error word was unable to open when i copy just the cells that have data to a new sheet i can complete the merge. Of these, only one of the letters does not work properly. But now i'm stuck with an error when the following code runs to the opendatasource command.