Mail Merge using ACCESS

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.

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Sue Sweet" wrote in message
...
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.

On Fri, 10 Jul 2009 09:46:16 -0700, Sue Sweet
wrote:

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.
--

John W. Vinson [MVP]

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

"John W. Vinson" wrote:

On Fri, 10 Jul 2009 09:46:16 -0700, Sue Sweet
wrote:

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.
--

John W. Vinson [MVP]