Mail Merge using ACCESS

[Sue Sweet]

First time using Access2003 to build a database & mail merge. I am trying to
mail merge
from a query. I want to merge all the records that the zip code begins 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.
I get the error message that there are no records in my query. If I go back
to ACCESS and remove my criteria so my query now has all the records showing,
the merge will work. This is where I am stumped. I am not sure is the
problem is WORD or ACCESS.

Thanks for any help.

 

[Arvin Meyer MVP]

bigger hammer. I can't tell you what the problem is from your description,
but I can solve it. Put your criteria back in and change the query to a
Make-Table. Then do the merge on the table. Delete the table when you are
done.

 

[John W. Vinson]

First time using Access2003 to build a database & mail merge. I am trying to
mail merge
from a query. I want to merge all the records that the zip code begins 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.
I get the error message that there are no records in my query. If I go back
to ACCESS and remove my criteria so my query now has all the records showing,
the merge will work. This is where I am stumped. I am not sure is the
problem is WORD or ACCESS.

Thanks for any help.

Please open the query in SQL view and post the SQL text here.

 

[Sue Sweet]

SELECT [T OregonGolfAssoc].[Sent/mailed], [T OregonGolfAssoc].Zip, [T
OregonGolfAssoc].Company, [T OregonGolfAssoc].FirstName, [T
OregonGolfAssoc].LastName, [T OregonGolfAssoc].Address1, [T
OregonGolfAssoc].City, [T OregonGolfAssoc].St, [T OregonGolfAssoc].Phone, [T
OregonGolfAssoc].Fax, [T OregonGolfAssoc].Email, [T OregonGolfAssoc].Title,
[T OregonGolfAssoc].DupCheck
FROM [T OregonGolfAssoc]
WHERE ((([T OregonGolfAssoc].[Sent/mailed])=No))
ORDER BY [T OregonGolfAssoc].Zip, [T OregonGolfAssoc].Company;

The query seems to work. I have a total of 816 records and query with the
criteria of ("970*) pulls 151 records. But when I open word and go to
MAILMERGE, that is when I get the message that there are no records.

Thanks