how do I associate a query to SQL code in a Word 2003 mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mm1861 - 23 Mar 2005 19:49 GMT

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

Reply to this Message

Cindy M -WordMVP- - 24 Mar 2005 12:40 GMT

Hi =?Utf-8?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
[quoted text clipped - 4 lines]
> 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 :-)

Reply to this Message