I am trying to use the advanced filters. We have an Excel spreadsheet that
we have our list and are merging it with a form in Word. The Excel file
contains a number of criteria that we want to use to filter the merge
recipiants however it's not working. For example, one column of the Excel
spreadsheet contains a number code. I would like to select all but three
codes. So I selected, the field, "not equal to" and the entered the first
number code. I connected it with an "and" (I also tried "or") to the next
item, which was the same field, "not equal to" and the second number code and
followed that with the third line item with the next number code. There
should have been a lot more records selected than actually showed up. What
am I missing?

Second. I have been able to use two criteria and get that to work, but when
I want to go back and change the filter criteria, it's not viewable. Do I
always have to re-attach the Excel spreadsheet each time I want to change the
filter criteria?

Thank you for your help with this.
Jan
--
Jan L