Mailmerge using SQL server

[Sydney Lotterby]

(Win2Kpro,Office 2003, MSSql 2000)
How can I (step by step from within MSWord) use a query of data in a large
SQL2000 db table to merge into an MSword doc?
If it needs MS Query - where can I download it from?

tia

 

[SA]

Sydney:

You don't need MS query.

1.) Start the Mail Merge Wizard Tools -> Letters and Mailings -> Mail
Merge
2.) Step through the merge wizard until you get to the pane to select
recipients and click the browse option
3.) In the Select Data Source dialog click: "+New SQL Server
Connection.odc"
4.) Enter the connection information to the SQL server (contact your admin
if your not familiar with server name syntax)
5.) Select the database and table that contains the contact information
6.) Once the mail merge recipients dialog is displayed showing the fields in
the table, select the field you want to use
as a filter and from the drop down arrow at the top of the field name,
select Advanced.
7.) In the Filter and Sort dialog, enter the field names and criteria you
want to use to select the recipients

Proceed with the Wizard prompts.