If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mailmerge using SQL server
(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 |
#2
|
|||
|
|||
Mailmerge using SQL server
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. -- Steve Arbaugh MS Access MVP "Sydney Lotterby" wrote in message ... (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 |
Thread Tools | |
Display Modes | |
|
|