Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Pre-set Query Conditions that cannot be changed | Mailmerge | |||
Inactive Word document window after completing Mail Merge 2003 | Mailmerge | |||
WP merge file to Word | Tables | |||
Using Word Mail Merge feature for custom templates | Mailmerge |