Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
crimsonkng
 
Posts: n/a
Default Mail Merge - how can I use MS-Query in Word 2003?

In my MS-SQL database, I have two tables that I want to use to extract names
and addresses in order to perform a mailing. IINFO has names, addresses,
postal codes. STAY has the arrival and departure dates. There's a field in
IINFO called IRECID that is the "key" used by STAY in order to attach each
Stay record to one or more IINFO records.

In previous versions of Word, I was able to use MS-Query to connect the two
tables and add criteria in order to obtain the names and addresses to whom I
wanted to send a mailing (based on arrival and departure date). The problem
is that in Word 2003, it looks like MS-Query is not available AND Mail Merge
allows me to use only one SQL table at a time.

I suppose that I could Excel to grab the desired data and then export the
results to Word but that's a pain in the ass.

So, I guess my question is: when using Mail Merge in Word 2003, how do I use
two, different SQL tables for mailing criteria and results?

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
Converting WordPerfect 12 files to Word 2003 Curious New Users 4 May 19th 23 02:48 PM
Pre-set Query Conditions that cannot be changed Charity Event Secretary Mailmerge 4 April 17th 06 05:56 PM
Inactive Word document window after completing Mail Merge 2003 Paula Mailmerge 0 March 27th 06 06:41 PM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM
Using Word Mail Merge feature for custom templates S.Sanghani Mailmerge 3 January 11th 06 10:22 AM


All times are GMT +1. The time now is 04:58 AM.

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"