Does anyone have experience with using excel to do mail merges in Microsoft Word?
We recently have had an issue where we go through our process to do a mail merge, but then it's not finding the data. This is the current process:
1) Open Word document we need for merge
2) Click Mailings > Select Recipients > Use Existing List
3) From here, I find the spreadsheet I'd like to use, it asks me to choose a worksheet...I choose the appropriate worksheet within the spreadsheet, but then I am getting a pop-up asking me to choose a table (see attached image).
With this particular file, it does not do this for the other worksheets in the spreadsheet, just one is not working. It can't find the data source. Does anyone know what's going on and how to fix it?
Thanks!
Bookmarks