All Queries not showing during Mail Merge

[Guest]

We do mail merges with queries developed from Microsoft Access. We used to
use Access 2000 but now have a new PC with Access 2003. Anyway when we do
the mail merge wizard we can only see a limited number of queries in our
Access database. It looks as if the complex queries with subqueries are the
ones that are not being displayed. If we use complex queries that have
already been setup as mail merges previously the mail merges work fine.
However we cannot find the other queries when want to do any new mail merges.
I am not sure if this is a access problem or what. The mail merges work
fine but creating any new ones is impossible because some queries are not
showing up from the database when we go through the merge wizard. Let me
know if you need any other information to help me out.

 

[Guest]

Hi Andy-

I can't be certain about what you mean by "complex queries", but Word cannot
use certain queries if they involve parameter prompts, SQL statements,
Crosstabs, etc. Perhaps that could be the problem.

HTH |:>)

 

[Albert D. Kallal]

You could as a workaround use my word merge. It does not matter what you use
for the sql or query.

You can find it here:

(give the sample a try...and if it suites your needs, then consider reading
the instructions on how to use the above in your application).

 

[Guest]

However these queries were working when we used them with Word 2000/Access
2000. Does this make sense?