Using stored procedures to retrieve Synergetic data

Stored procedures can be used to return Synergetic data to Microsoft Word to create mail merge letters. The procedures also update Synergetic fields so that history is kept about what has been mailed when.

For details of stored procedures, see Stored procedures.

How to

• Add an activity for a future student, to include in a mail merge letter. See Future Student Maintenance - Activity tab in the Future students manual.
• Change the status of a future student's application, to include in a mail merge letter. See Future Student Maintenance - Applications tab in the Future students manual.
• Select several future students and add activities for them. See Adding future student activity in bulk in the Future students manual.
• Create new mail merge letters. See Creating mail merge letters using stored procedures.
• Print using existing mail merge letters. See Printing mail merge letters using an existing document.
• If you have access, reset values in bulk for the selected records in the Synergetic maintenance function. See Setting field values in bulk in the Introduction manual. Alternatively, create new activities or applications.
• Reprint individual letters. See Reprinting mail merge letters.

Last modified: 7/11/2011 1:25:16 PM

© 2014 Synergetic Management Systems. Published 12 September 2014.