Reply
 
Thread Tools Display Modes
  #1   Report Post  
mm1861
 
Posts: n/a
Default how do I associate a query to SQL code in a Word 2003 mail merge

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
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Documents in Word 2003 and Word 2002 - VERY Weird Proble Joshua Gray Microsoft Word Help 5 February 18th 05 10:09 PM
copying files from Wordperfect to Microsoft Word Juliet New Users 1 January 31st 05 06:41 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 13th 05 12:30 AM
WordPerfect - copying formatting Morgan Page Layout 1 January 10th 05 06:00 PM
How do I convert a cd in word perfect to microsoft word greylady Microsoft Word Help 1 November 23rd 04 08:03 PM


All times are GMT +1. The time now is 12:16 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"