Forum Discussion
Word Mail Merge Filter Issue
Hello and thank you to all that can help me understand what if anything I am doing wrong here. I am trying to mail merge a document using data in my excel file for the merge. The issue is I want to ...
And.. ok ... it turns out... filters don't work properly, known and ancient and never fixed bug. There's a reply from "A User" in this thread https://answers.microsoft.com/en-us/msoffice/forum/all/word-2016-mail-merge-filter-does-not-work/de1d0149-9ab1-467a-b5f3-64b7218fdd8a that explains the root of the evil is some broken query expansion behaviour. In my case I had a <string field> "not equal to" "something" clause and the broken expansion decided "ahhhh.. null (blank) is not equal to "something" so so it threw in an "or blank" clause... I added an AND <string field> "not blank" and it fixed it for my case, I'm not sure how to "fix" yours though...