Forum Discussion
mail merge select recipients got broken
This feature worked before with an office enterprise 2007, but it started behaving oddly some days ago.
Option 1. type a new list throws error: Class not registered
Option 2. use an existing list creates wrong file path by cutting the file name and appending file extension to the last folder.
E.g.: the file to be used as data source in mail merge is C:\Users\me\folder1\folder2\data.xlsx, but the mail merge dialog box shows: C:\Users\me\folder1\folder2.xlsx
In step by step mailmerge wizard, there is not option to select excel data source at step 3/6. I can select "Special" and then narrow down to Excel files, but no table data is shown after selecting any .xls(x) file.
Most probably this freature has been broken since an office pro plus 2019 installation attempt (but i m not sure 100%).
Is there a common office registry setting that blocks this feature and makes such weird behavior?
Excel source file is healthy, it works perfectly on other PCs with mail merge.
2 Replies
Consider this:
- Enable file format conversion on open
- Use Dynamic Data Exchange (DDE) for Excel files
- Try Office Compatibility Mode
Not sure what it does in the background, but rebooting after Repair in Apps-Modify-Repair made the job. There was a power outage the night before in the office during a Windows update. It might have negatively impacted Office programs.
