We’ve been asked several times on how to create mailing address labels for parents. This can actually very easily be done using MS Excel and MS Word. Here’s a quick tutorial:
First, Download the Mail Merge file from QuickSchools
Assuming you have access, just go to “Reports”, and find the “Parent Data for Mail Merge” report on QuickSchools, attached to “Current Student Data”. It is most likely on page 2 or 3 of your “Reports” menu.
Just click on the “Excel” button to download, and save it on your local machine.
Next, Open up MS Word. There are actually 3 steps here:
1 – “Start Mail Merge”: This is where you decide the format of the label. You may want 30 labels per page, for example:
2 – “Select Recipient List”: This is where you select the Excel file that you downloaded.
3 – “Insert Merge Field”: This is where you select which fields to include in your label.
The steps may differ slightly depending on the version of MS Word that you’re using. And you can probably find lots of tutorials for this on YouTube. Here’s one I found particularly useful:
Shout out to Ralph Phillips for putting together an awesome video. If you need help with this, please feel free to come chat with us.
3 thoughts on “Mailing Address Labels for Parents via Mail Merge”
[…] this new feature will alleviate the need for a published Parent Directory (which is typically done via Mail Merge), since parents will now have the most accurate contact information available via the Parent […]
[…] http://blog.quickschools.com/2013/06/06/mailing-address-labels-for-parents-via-mail-merge/ […]
[…] can even be scheduled. This works by using columns from the report as fields in your email (like a Mail Merge). However, if you attempt to remove columns from your report that are actually being used in your […]