I seem to have a problem using mail merge that Word only recognizes certain
queries for use as a data source for a mail merge. I have a template I
created in Office 2000 that calls the OpenDataSource method. In there I
indicate the query that I want to use in the connection parameter.

When my users create a document based on the template and run the query they
get the Select Table dialog. In there only some of the queries appear. I have
compared some that appear there with the one I want to use and cannot see any
differences. It is a basic, non-union, select query. Another interesting
point is that I create a connection string to the db that I am using, to set
the queries sql, and also use the same string as the Name parameter so I know
I am pointing to the correct database. When I try to open the data source
manually I have the same problem in that not all of the queries appear in the
Select Table dialog.

Any thoughts?