Problem about Ms Word 2016 Mail Merge Filter

Chi Kin 1 Reputation point
2022-11-03T11:30:55.657+00:00

I am using Ms Word 2016
I linked a Excel sheet to a Word for making mail merge

I used two conditions in filter.
256755-1.png

However, when I pressed Enter, I found many data which did not matched with my conditions.

When I checked the conditions, I found much more conditions were automatically added to the filter
The conditions were using "Or" function. As a result, my conditions were void and many unrelated data was used.
256804-2.png

Does anyone know what did I do wrongly? Any solutions?

PS. I am using Chinese version. In the pictures, "且"means "and" and "或" means "or"

Microsoft 365 and Office Excel For business Windows
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.