View Single Post
  #3   Report Post  
Diane Hazen
 
Posts: n/a
Default

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.