Query and mail merge

G

Guest

I have a query where the users enter in a specific criteria and get one
result from the table. This query is linked to a mail merge letter.
In office 2000 it works.
However, I am using office XP and the mail merge does not allow me to use
the criteria query.
Any ideas how I can make it work?

Thanks
 
S

Steve Schapel

Jaimi,

This is a limitation of recent versions of Word. The only way I know of
to handle this is to use code within Access to write the required data
to a temporary table, and then set the Word mail merge to use this table
as the data source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top