...
- Open Microsoft Word.
- Select:
• Mailings > Start Mail Merge (Microsoft Word 2010)
• Tools > Letters and Mailings > Mail Merge (Microsoft Word 2003).
Step 1 of the Mail Merge tab is displayed on the document window. - Select the type of document you are working on.
- Click Next: Starting document.
Step 2 of the Mail Merge tab is displayed on the document window. - Select the starting document.
- Click Next: Select recipients.
Step 3 of the Mail Merge tab is displayed on the document window. - Click Browse.
The Select Data Source window is displayed. - Select Tools > MS Query.
The Choose Data Source window is displayed. - Select the Synergetic database you plan to use. That is:
• SynergyOne for mostly non-financial data
• SynergyOneFinance for finance data. - Clear the Use the Query Wizard to create/edit queries field.
- Click
The SQL Server Login window is displayed. . - Type in your username and password.
Note: This is your usual Synergetic username and password. - Click
The Add Tables window is displayed. . - Click .
- Click
The SQL window is displayed. . - Type the stored procedure and its parameters. See Stored procedures for details of each procedure. In this example, type:
• exec
• the procedure name, crspFutureActivityPrint
• the first parameter, @Activity='<code>', where <code> is the activity code required
• the second parameter, @Campus='<campus>', where <campus> is the campus required.
Note: In this example we have omitted the campus parameter. - Click
The following dialog window may be displayed. . - Click
The Microsoft Query window is displayed with the data returned by the stored procedure. . - Select File > Return Data to Microsoft Word.
The Mail Merge Recipients window is displayed.
Note: Ensure that you return this data as soon as possible, as the data from Microsoft Query is not available for longer than 15 minutes.
- Click
Step 4 of the Mail Merge tab is displayed on the document window. . - Click More Items.
The Insert Merge Field window is displayed. - Locate and select the field to insert into the document.
- Click
The field is inserted in the document. . - Repeat steps 22 and 23 until all of the required fields are added to the document.
- Close the Insert Merge Field window.
- Add other text and format the letter.
- Click
- Format any database fields, such as date fields with the time included.
Tip: Right click and select Toggle Field Codes, to format the date, such as @ "d/mm/yyyy". - Preview the output and merge the letters.
- Save the document.
This document can form the basis of other similar letters based on future student activities.