View Single Post
  #4   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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.