Mail Merge is an much loved/hated feature of Microsoft Office. However it remains one of the few ways to produce personalised print material.
Admin or Staff permissions are required.
Export your data as an XSLX file
Navigate to the directory view
Apply the filters that you require
Check the results match your expectation
Click the green download icon at the top right of the directory
(If you have families / household then use the "additional family member" tag to exclude family members and just send one per house.)
Mail Merge
(instructions may vary depending on your version of Word)
Open your mail merge template
From the Mailings menu pick 'Select Recipients'
Choose 'Use an existing list'
(Word may ask about an Excel workbook convertor - click OK)
Choose the entire workbook if prompted
The available fields will be populated in the "Insert Merge Field" dropdown
Add fields as required
Click preview results to verify
Want more filter options?
The blue button at the top right of the directory is an advanced filter view. If you want a filter that isn't available please contact support@sheepcrm.com
Want more fields included in the export?
Please contact support@sheepcrm.com and we can configure your export to include more fields. Sorry this isn't yet available as self service