I went back to the letter, redid the list by selecting the fields that I
wanted, did not go through and ck/unck specfic records, saved the file. I
then opened it again and reviewed the list and it isn't the one I saved. Some
records are right, but most are wrong. Obviously something is amiss.

The way I set it up is to follow the dialogs (or whatever they are called)
on the right side of the page--select list, edit list, preview letter, merge,
etc.

I can't copy the SQL, but it is correct in terms of what I have asked in the
list. But as I mentioned before, the SQL when applied includes records that
it shouldn't. As an example I ask that the address field "is not blank", and
of two other fields one "is blank" and the other "is not blank". But when the
list comes up, there are lots of records where the address IS blank. The
field that I ask to be blank, in fact is, the other filed (is not blank) does
include records that are blank.

The only other thing I could do is send you the complete files (but you
probably don't want to wade through these).

I really appreciate your help.
D Hazen

"Peter Jamieson" wrote:

Unfortunatey I can't replicate this here as my similar example works OK.

If you save, close then re-open your mail merge main document after you have
applied all the criteria, do you see a dialog box with some SQL that
specifies the various criteria you have applied (it won't reflect the
individual records you have selected/deselected by checking/unchecking). If
so, can you post the SQL here please?

Peter Jamieson
"Diane Hazen" wrote in message
...
I first do an advanced search on the three fields, using an "and" to link
each of the fields. This gets my list down to about 60 records. I then go
through and uncheck all those on the list I do not want to specifically
include--down to the 30 I want. The 30 records are all checked and are the
ones I want.

I tried to do a table of this list also and got the same results (all 300
names) as I was getting with the letter.

Thanks for your help
Diane Hazen

"Peter Jamieson" wrote:

How are you reducing the list? Are you doing it by checking/unchecking
records in the recipient list, using a query in Access, or what?

Peter Jamieson
"Diane Hazen" Diane wrote in message
...
I have also updated Access and Work to 2003. I am doing a "simple" mail
merge
using 3 fields to limit my letters. My Access file is 300 records. When
doing
the merge query, I am able to reduce the list properly to the 30
clients I
actually need. But, when I do the merge--ALL records are merged, not
the
30 I
need. I am using an existing merge letter. This is driving me crazy. I
am
not
a novice "merger" and never had problems with Office 2000.