Creating Custom Form Letters and Reports

You can use the Export to Text capability of Gradekeeper together with the mail merge capability of Microsoft Word to create custom form letters or reports.

• First, export the items you want in your report from Gradekeeper:
• Choose Export to Text from the File menu
• Choose the items you want in your report
• Click the Export button
• Choose a name for the text file
• Click the Save button

Next, start Microsoft Word. Choose Mail Merge from the Tools menu. The Mail Merge Helper will appear:

In the Main Document section, click Create and choose Form Letters. You can choose to use the active window or to create a new main document. In the Data Source section, click Get Data and choose Header Options. In the Header Options window, click the Create button. The Create Header Source window will appear:

Click Remove Field Name until all of the default field names have been removed. Then enter the field names you want. Your field names must match the items you exported from Gradekeeper and must be in the same order that Gradekeeper has them. Click OK when you finish entering your field names. The standard save dialog will appear. Choose a name for your header source document and click Save.

In the Mail Merge Helper, in the Data Source section, click Get Data. Choose Open Data Source. The standard open dialog will appear. Choose to show files of type text and choose the text file you exported from Gradekeeper.

After you choose your text file, the Header Record Delimiters window will appear:

Choose tab as the field delimiter and enter as the record delimiter, then click OK.

You can now type your form letter. To insert one of the items you exported, choose it from the Insert Merge Field button in the toolbar. When you are done typing your form letter, it may look like this:

You can now create a merged document by clicking the Merge button in the toolbar:

You can also choose to send your form letter by email. Your data source (the text file you created when doing the export to text from Gradekeeper) must include an email address for each student. You can add those email addresses using Microsoft Excel. Open the text file with Excel. Copy and paste the email addresses into a blank column from the document where they are saved. Microsoft Outlook must also have an email address and SMTP server set up.

Once you create a mail merge document, you can use the same mail merge document many times. Simply change the data source to the text file you exported from Gradekeeper, and create a new merged document.