How Can I Email Letters?

Overview

For complete setup of emailing letters, refer to the instructions below.


It is recommended the user logged into the system has an email established email account in the system.

Users should not login with "admin" in order to run email exports.

Additional Insight to Emailing Letters

Email addresses captured by MySchoolApps and Franklin will only be used when generating application-based letters. However; if no email address has been provided on an online, scanned, or keyed application, the system will then generate a letter to the email provided in the SIS, if available.
Other letters generated by Franklin utilize the email address associated with the student's record (imported via SIS or manually added).

When emailing letters, if a letter is manually queued (e.g. Student Lookup | Letters | Queue), the letter will be sent to the SIS email on file and not the App email.
When reprinting a batch (Home | Review Batches | Reprint Batch(es) ), any batches previously set to email will be printed - not emailed.

 Letter Reasons: Uses email on Application versus Uses Email from SIS
Letter ReasonUses Application EmailUses SIS Email


*If no email has been provided on an application
Application ProcessedX
Incomplete Application (Paying)X
Ignored Decreasing Benefits ApplicationX
Verification CompletedX
Invalid Verification ResponseX
Missing Verification ResponseX
Zero Income WarningX
Zero Income ExpiredX
Explanation of Benefits
X
Incomplete Application (Already Free)X
Incomplete Application (Already Reduced)X
Special Circumstances Changed
X
Area-Eligible Grace Period
X
Processed Economic SurveyX
Incomplete Economic SurveyX
DC Notification
X
DC Reduced
X
Prior-Year Warning
X
Prior-Year Expired
X
Verification SelectionX
Verification WarningX
Verification ExpiredX

Review/Establish Email Address for Users

  1. Locate the Admin and Maintenance tab and select Users.
  2. In the Email Address column, click and add or edit the user's email address. Click Save Changes after you are done.

Return to Top


Establish Host Server Details

  1. Locate the Admin and Maintenance tab and select System Settings
  2. Select the Email tab and establish SMTP details and click Ok once you are done.

    Contact your IT department for SMTP setup details.

Return to Top


Establish Custom Text in the Form of Custom Strings (Optional)

Custom Strings allow you to add additional text to letters. There are numerous steps to complete in order for this to work.

  1. Locate the Admin and Maintenance tab and select Miscellaneous Setup. Then, select the Letters and User-Defined Tokens.

  2. Complete Custom Letter Token details. Click Save Changes after you have established Custom Letter Token details.
    • Token Name - A title to differentiate customized additions.

    Token Names must start with two (2) letters or an underscore and can only contain letters, numbers, and underscores. Spaces are not allowed.


    • Kind - Choose if the custom token is Plain Text, Rich Text, or a Formula.
    • Formula - If the Kind is set as a formula, use the ellipsis  button to complete formula options.

    A good understanding of SQL language and queries are necessary in order to create successful formulas.



  3. Locate the Admin and Maintenance tab and select Miscellaneous Setup. Then, select the Letters and Custom Strings.
  4. Locate and expand Section: custom by clicking the plus + sign. Then, Enter custom information for the resource in the Custom Text column. Click Save Changes when you are done.

    If you have additional language letters, you must complete the Custom Strings for each language. Translations are completed by someone in-house of the District.



  5. Locate the Admin and Maintenance tab and select Miscellaneous Setup. Then, select the Letters and Letter Templates.
  6. Choose Add to create a new letter template. You may also select an existing Letter Template and choose Edit Printed Template or Edit mail Template to edit the template.
  7. Make changes to the template.
 Printed Letter Template
  • Make any adjustments to existing bands, fields, labels, and text boxes to ensure you have room for the Custom Text.
  • Select the Field List tab and scroll to locate UserDefinedTokens and click the plus + sign to expand options. (You can also type the field name.)
  • Select the field by clicking on it and dragging it to the letter template.
  • Make necessary adjustments to the size of the field box.
  • Click the Preview button at the bottom of the screen to view the letter. 

Click the Save  button after you have made all the necessary changes.

 Email Template
  • Make any adjustments to the Subject and Body of the template.
  • Select Insert Token to add student application information fields to the template. The location of your text cursor in the template will determine the location of the token.
  • Click the Test Preview button to view the email letter.
  • Select the checkbox to Attach a PDF document including the printed letter.

Click the Save Changes  button after you have made all the necessary changes.

Return to Top



Establish Letter Batch Kinds Rules

  1. Locate the Admin and Maintenance tab and select Miscellaneous Setup. Then, select the Letters and Letter Batch Kinds.
  2. Use the drop-down arrow to select the Letter Template for a letter if you have created a customized letter template.
  3. Click the plus + next to Normal Letters. Drag and drop letter reasons to the Letter Reasons box for the appropriate template.

     Letter Reasons - Click here to view optional Letter Reasons.




  4. Click the Output Rules tab to establish output settings.

    Establish output rules by entering sequences. The first sequence should be an email output. If an email does not exist, the second sequence will then place letters in the print queue.

    Configure formulas for each sequence by clicking the ellipsis  button. Each District's output rules may vary according to regulations or preferences. Test the formula before clicking Ok to apply the formula.

     User Defined Formulas - Click here to view User Defined Formula options.

       

     

  5. Click the Save Changes button at the top-left corner of your screen when you are done.

Return to Top


Establish Letters to Export

  1. Locate the Admin and Maintenance tab and select Advanced Setup. Then, select the Exports.
  2. Click the Add New button and select Email Letters from the Add New Export window. Then, click Ok.
  3. In the Configure Export window, enter a description of the export. Then, click the Setup button.
  4. In the Setup Email Letters window, use the drop-down arrow to select the Letter Batch Kinds. Then, click Ok.
  5. Click Ok in the Configure Export window to save changes.

Return to Top


Export Letter Data and Establish Scheduled Jobs

  1. Locate the Utilities tab and select Advanced. Then, select the Export Data.
    .
  2. Select the data you wish to export and click Run.
  3. (Optional) Locate the Admin and Maintenance tab and select Advanced Setup. Then, select the Scheduled Jobs.
  4. Select the nightly or daily tasks and click the Edit button.
  5. Click the Add Task button.
  6. Choose the Export Data task and click Ok.
  7. Choose the export you wish to include in nightly tasks and click Ok.
  8. Click Ok in the Edit Scheduled Job window to save changes. Select Run Now to run the Export now or Close to the close Scheduled Job Maintenance window.

Return to Top