Creating a Mail Merge using data from a Custom Report Writer report

Merge fields allow you to include information specific to the recipient of the SMS, email or letter. In your communication template or draft you will see a generic merge field. When previewing the communication and when sending it out, the merge field will be replaced with the information specific to the recipient.

Screenshot_2023-05-04_at_11.07.44.pngScreen_Shot_2019-04-04_at_09.23.58.png

 

You can also create merge fields using information from a Custom Report Writer custom report you have made. You can do this from any report regarding Students. This allows you to set a precise set of recipients (using the filters in CRW) and then complex columns (e.g. meal balance or % attendance this term). 

Permissions

  • School Communications Send and administer school communications: Administer All Students - set up communication templates
  • School: General Admin: Export Data - Create custom reports

If you don't have the permission, you'll need to ask your admin team to give you permission using these instructions.

 

Using a Custom Report to create Merge Fields

To create a Mail Merge, navigate to Custom Report Writer by going to School > Custom Report Writer.

Create the Custom Report by choosing the specific filters you need to narrow down the group of students you wish to create a mail merge from. Then add the columns you wish to include in the Mail Merge.

Return to view the report and from the top, select the Send Mail Merge button and select whether you wish to create an SMS, Email or Letter Mail Merge from the Custom Report. Please note: this option is only available if you do not have groupings in the report.

Top Tip: If you want others to use your email/letter/SMS templates created from custom reports, you'll need to share your report with anyone who needs access to the template.

mail_merge_crw.png

 

You will now be redirected to the Mail Merge you have selected. Choose the recipients, you can either choose the send the Mail Merge to the students or the guardians.

When you want to insert a column from the custom report writer into the body of the communication, click Merge Fields and click on the arrow at the bottom of the drop-down menu until you reach the options that start with Report field.

Then click on the field you want to enter and this information from the report will be entered based on each individual recipients data in the report.

Screenshot_2023-05-04_at_11.10.55.png

 

Example: Sending next year's Registration forms to Guardians

Once you've enrolled your applicants for next year into registration forms, you can let parents know what registration forms they will be in and their tutor.

To create the Custom Report, download the report template from this article and add it to your Custom Report Writer.

From the report, select the Send Mail Merge button and select whether you wish to create an SMS, Email or Letter Mail Merge from the Custom Report. Please note: this option is only available if you do not have groupings in the report.

Screen_Shot_2019-07-02_at_16.41.33.png

 

You will then be redirected to the Mail Merge you have selected. Choose the recipients, you can either choose the send the Mail Merge to the students or the guardians. 

We recommend choosing not to combine messages when using Merge fields. As the data is being taken from individual rows in a custom report, it can only pull in one data point at a time. Please select One per recipient, for each student.

comnine.png

 

In the body of the mail merge, you can insert the registration form data from the Custom Report. 

Once you are happy with your message, click Proceed to view previews of the messages and send the message.

Screenshot_2023-05-04_at_11.13.21.png

 

Example: Sending an SMS/Email to last year's Guardians

Go to School > Custom Report Writer and click Create new report.

Name your report and Select that your report is about students.

Screen_Shot_2019-03-13_at_09.27.57.png

 

Set the date range to be covering the Previous academic Year and click Next, then scroll to the bottom of the page and click 'skip setup wizard'.

Screen_Shot_2019-03-13_at_09.29.29.png

 

You can then add any filters here to determine whose guardians you would like to communicate with and add more columns if needed.

Filters are used to determine which data is included or excluded in your report. A report with no filters added would mean that all enrolled students will appear in the report.  You can use the filter options to view or remove certain groups of students.

Example: To create a report concerning students in Years 1 & 2, select Year Group(s) > Add Filter.

The next box to slide over will allow you to enter the specifics for the filter condition.  In this case you would select ‘Is one of…’ in the first box; ‘Year 1’ & ‘Year 2’ in the second box.

When happy with your report, click Save and view report.

Screen_Shot_2019-03-13_at_09.31.51.png

 

When viewing your report, use the Bulk action button and select the appropriate communication, this will take you into the communication area where you can send to the guardians of these students who attended in the previous year. 

Screenshot_2022-08-22_at_15.08.19.png

 

Communication Templates

You can link Communication templates to Custom Report data. Create a report in the Custom Report Writer, then go to School > Communications > Templates to create an Email, SMS or letter template using data from the report as a merge field. Perfect for following up with parents about low attendance marks!

Top Tip: If you want others to use your email/letter/SMS templates created from custom reports, you'll need to share your report with anyone who needs access to the template.

Screenshot_2022-01-12_at_12.41.52.png

 

Click +Add, and choose to base your template on a Custom Report from the Custom Report Writer.

Screenshot_2023-05-04_at_11.14.18.png

Screen_Shot_2019-05-08_at_16.13.57.png

Was this article helpful?
1 out of 7 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.