Hi Everyone,
I hope I can explain what is happening clearly enough.  
I have a Word mail merge with the datasource in excel. I
have always used the mail merge toolbar functions.  
Before 2003 (not sure what version I was using), I could
use the mail merge recipients button and use the advanced
selection to do a filter so that I would only get the
merges that met my criteria.  This does not work in
2003.  Here is what happens now.
I select the mail merge recipients button and I set my
first criteria  - so for example I say I want it to
select only the cells that are non blanks, then I pick my
second criteria  in a different column - for example I
say I want all cells that do not match "FRR". Then I pick
my third critera in the a different column - for
expample - all cells with NO.   So basically from my
datasource I only want to merge the ones that match this
criteria  (non blank in column entitled Course selection
AND do not equal "FRR" in colunm entitled Status AND
equal NO in column member).
When I look at the list below still in the box - the
answers are correct - it has worked.  But when I press
the okay button and look at which letters are actually
there it is no longer working.  I get letters I didn't
want.   When I go back to the mail merge button and see
what has happend to my criteria for some reason it now
as  OR criteria when I only put in AND critera.  
does anyone have any idea why this is happening?  Glitch
in 2003 version?   I used this all the time before
swtiching to 2003 and I had no problems.  
I would love to hear if anyone has any solutions has I
don't want to make multiple datasources.
Thank you.
Take Care,
Gabbi