Problem filtering in mail merge.
I have a problem trying to use multiple criteria to filter on.
This seems purely like a bug or random behavior, and not a usage issue, but please tell me if this is known or what i would need to do.
I filtered on a field, SendNow=1. Fine, i got 566 reciepients.
I then added AND Field=Bounced, criteria = IsBlank.
But, instead of getting fewer recipients, in fact, at that point, all rows were selected.
So, i looked at the dialog again, and it had simply added an extra criteria, and extra "OR" criteria that ended up selecting all the records. And, this is reproducible, happens every time i try to say OK to the dialog, i can't seem to prevent it.
When i click OK, what is added is an additional critera, with "OR", and Field-Bounced=IsBlank is added again.
So, when i thought i had
SendNow=1
AND Bounced IsBlank (and then hit OK in the dialog)
what the dialog had (when i opened it again) is
SendNow=1
AND Bounced IsBlank
OR Bounced IsBlank
That is, it simply added an extra criteria as "OR Bounced IsBlank". Of course the last set will select all records.
each time i simply open the filter dialog and click OK, an extra criteria
"OR Bounced IsBlank". I've gotten it up to like 10 times in the dialog, just by opening and saying "OK". Aside from the fun, this is is a big problem. I can't make the dialog stop at just two criteria:
SendNow=1
AND Bounced IsBlank
Am i crazy? Has this been seen? How do i get ONLY the above 2 criteria to be used. Every time i say OK to the dialog, i am back to all the rows being selected, no filter at all.
Yikes, help!
Thanks
tom
|