Access query to mail merge

[Sue Sweet]

First time using Access2003 to build a database. I am trying to mail merge
from a query. I have it all set up and and when I have no criteria and all
the records are showing in the query, it will show as a mail merge. If I use
the criteria in the zip field that I want only the records with zip beginning
with 970 (970*) and run the query, the records show in the query but when I
try to mail merge, I get the error message that there are no records in my
query. I am getting very frustrated

Sue

 

[Michael J. Strickland]

Did you try using:

Like "970*"

as your criteria for the query?

 

[Sue Sweet]

That is what I used. I wanted to merge all the records that the zip code
began with "970*". My query table looked correct. I drilled down from a
total of 817 records to 151. I saved my query and open WORD and the letter
and proceded to the mail merge wizard. I went through and set up the
document and opened my data source. When I opened the data source, it showed
0 records to merge. This is where I am stumped. I am not sure is the
problem is WORD or ACCESS

 

[Steve Schapel]

Sue,

I am not sure whether this applies to your situation there. However, in
some cases Microsoft Word is quite "iffy" about using an Access query as a
data source. I have resorted to putting a temporary table in the database,
which is used as the data source for the merge document, and then using a
VBA procedure to clear the data from this table, and then append the records
returned by my query. Hope that makes sense.

--
Steve Schapel, Microsoft Access MVP

First time using Access2003 to build a database. I am trying to mail
merge
from a query. I have it all set up and and when I have no criteria and
all
the records are showing in the query, it will show as a mail merge. If I
use
the criteria in the zip field that I want only the records with zip
beginning
with 970 (970*) and run the query, the records show in the query but when
I
try to mail merge, I get the error message that there are no records in my
query. I am getting very frustrated

Sue

__________ Information from ESET Smart Security, version of virus signature database 4247 (20090715) __________

The message was checked by ESET Smart Security.

http://www.eset.com