Can I Mail Merge documents in a Comms email?

The Comms module in ScholarPack does not accommodate Mail Merge, but you can generate an excel file then follow this guidance to perform the action in Microsoft Word. 

How to use the Mail Merge feature to create and to print form letters that use the data from an Excel worksheet. 

mceclip4.png

You can filter the Year Group and Contact Order columns by entering the required number, then pressing return (e.g. Year 6 and Contact 1 in the example below). This will display all the contacts 1 for that year group, with their email address and other contact details

mceclip5.png

To remove any columns you don't require, click on the dustbin icon at the top of the column. Then to download this as an excel file click on the yellow arrow in the top right of the screen. 

                                                              mceclip6.png

 

Was this article helpful?
0 out of 0 found this helpful