Page Comparison

In the following example, letters are being prepared to mail to the parents of each future student who has an interview booked with the Head of Campus, using the crspFutureActivityPrint stored procedure.

An activity has been created on the Activity tab of Future Student Maintenance. See Future Student Maintenance - Activity tab in the Future students manual.Image Removed

Image Added

In the example, the interview is booked with Sarah Adamski and her parents, as displayed on the:

• Activity tab (selected above)
• Modify Activity window (seen below).Image Removed

Image Added

Activities are selected for the mail merge based on their Activity and the Mail Request field. However, if the Mailed Date and Mailed By fields are populated with values, this means that this activity has already has been printed.

The Activity field codes are maintained in the luActivity lookup table. In this example, INTBOOK INTERVIEWwiki has been created for interviews that have been booked. See Maintaining lookup tables in the System maintenance manual.

To create mail merge letters using a stored procedure, such as the crspFutureActivityPrint procedure:

1. Open Microsoft Word.Select:.
2. Click the Mailings tab.
   The Mailings tab is displayed.
   Image Added
3. Click Image Added.
   
   • Mailings > Start Mail Merge (Microsoft Word 2010)
   • Tools > Letters and Mailings > Mail Merge (Microsoft Word 2003).
   
   
4. Select Step-by-Step Mail Merge Wizard from the drop-down list.
   Image Added
   Step 1 of the Mail Merge tab is displayed on the document window.
   Image RemovedImage Added
5. Select the document type of document you are working on.
6. Click Next: Starting document.
   Step 2 of the Mail Merge tab is displayed on the document window.
   Image RemovedImage Added
7. Select the starting document.
8. Click Next: Select recipients.
   Step 3 of the Mail Merge tab is displayed on the document window.
   Image RemovedImage Added
9. Click Browse.
   The Select Data Source window is displayed.
   Image RemovedImage Added
10. Select Tools > MS Query.
    Image Added
    The Choose Data Source window is displayed.
    Image RemovedImage Added
11. Select the Synergetic database you plan to use. That is:
    • SynergyOne for mostly non-financial data
    • SynergyOneFinance for finance data.
    

    Note: Entries prefixed with 'SynergyOne' are pre-Version 68 entries.

12. Clear the Use the Query Wizard to create/edit queries field.
    Image RemovedImage Added
13. Click Image Removed Image Added.
    The SQL Server Login window is displayed.
    Image RemovedImage Added
14. Type in your username and password.
    
    Note: This is your usual Synergetic username and password.
    
    
15. Click Image Removed Image Added.
    The Add Tables window is displayed.
    Image RemovedImage Added
16. Click Image RemovedImage Added.
17. Click Image RemovedImage Added.
    The SQL window is displayed.
    Image Added
18. 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.
    Image RemovedImage Added
    Note: In this example we have omitted the campus parameter.
19. Click Image Removed Image Added.
    The following dialog window may be displayed.
    Image RemovedImage Added
20. Click Image Removed Image Added.
    The Microsoft Query window is displayed with the data returned by the stored procedure.
    Image RemovedImage Added
21. Select File > Return Data to Microsoft Word.
    
    The Mail Merge Recipients window is displayed.
    Image RemovedImage Added
    
    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.
     
22. Click .
    Step 4 of the Mail Merge tab is displayed on the document window.
    Image RemovedImage Added
23. Click More Items.
    The Insert Merge Field window is displayed.
    Image RemovedImage Added
24. Locate and select the field to insert into the document.
25. Click.
    The field is inserted in the document.
26. Repeat steps 22 and 23 until all of the required fields are added to the document.
27. Close the Insert Merge Field window.
28. Add other text and format the letter.
    Image RemovedImage Added
29. Click Image Removed Image Added to view the merged data.
    Image RemovedImage Added
30. 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".
    Image RemovedImage Added
    
    
31. Preview the output and merge the letters.
32. Save the document.
    This document can form the basis of other similar letters based on future student activities.