Select Table dialog in Mail Merge

[RobertH]

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?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Um9iZXJ0SA==?=,

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.

Starting with Word 2002, the default connection method was changed from DDE to
OLE DB. This required changing the OpenDataSource method, and an argument was
added to accomodate. See this article

http://support.microsoft.com/default.aspx?scid=kb;en-us;279462

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.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail