ok, I've written several mail merges and have used a variety of queries in
Word 2003 over the last couple of months. Now, I'm having problems getting
exactly what i want with one of the early merges, and would like to look at
the query to modify it. I can view the SQL code, but can't seem to find the
name of the query associated with the code. I can make a SQL change to
modify the query and save to a new name, but would like to be able to
associate the code with the original name so don't end up with a bunch of
clutter. Thanks, in advance. mm

Hi ?B?bW0xODYx?=,

I've written several mail merges and have used a variety of queries in
Word 2003 over the last couple of months. Now, I'm having problems getting
exactly what i want with one of the early merges, and would like to look at
the query to modify it. I can view the SQL code, but can't seem to find the
name of the query associated with the code. I can make a SQL change to
modify the query and save to a new name, but would like to be able to
associate the code with the original name so don't end up with a bunch of
clutter.

I'm not 100% sure I understand. Are you saying you want to know the actual data
source (query, not table) to which your merge document is linked?

Try Help/About/System Info. Look for the Word application, and in the mail
merge section you should find the information. Other than that, you can try
ActiveDocument.MailMerge.DataSource.ConnectString
ActiveDocument.MailMerge.DataSource.TableName

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 :-)