Click on images to expand in a new tab
Overview
The Mail Merge feature in AdviserLogic is designed to help you generate personalised client communications efficiently by combining dynamic client data with your own document templates. Built to work with Microsoft Word’s Mail Merge functionality, this tool allows you to quickly produce tailored correspondence at scale.
You can easily create documents such as welcome letters, review reminders, advice cover letters, or any client-facing communication that requires personalisation.
Mail Merge draws data directly from AdviserLogic fields—such as client names, contact details, account numbers, and adviser information—ensuring each document is accurate, consistent, and professionally presented.
Whether you’re generating a single document or running a large-scale communication campaign, Mail Merge helps streamline the process while enhancing the overall client experience.
📌Note
The Mail Merge section closely resembles the Email section in AdviserLogic and shares much of the same functionality, with one key difference: it does not send emails. Selecting Generate will not deliver anything to clients. Instead, it produces a document with merged client data, which you can print, save, or physically mail as needed.
Access
To access the mail merge function, navigate to Tools > Adviser Tools > Emails > Mail Merge.
This will open the Mail Merge window, where you can manage templates, choose recipients, and generate personalised documents using client data from AdviserLogic.
Mail Merge Fields Explained
Allows you to choose or manage client groups for bulk communication. | |
A drop-down menu to select a pre-existing template, or option to create a new one. You May select the Template button to manage existing templates. | |
📨To | Specifies the client(s) who will receive the generated document. Populated based on the selected Group or individual. |
A rich text editor where you can enter and format your message. Includes tools for styling, bullet points, links, tables, and inserting merge fields. | |
🔢Characters | Displays the character count in the body of your template – useful for tracking content limits. |
Creates the mail merge document with client data inserted. *Does not send any email. | |
💾Save | Saves your current template for future use or edits. |
👥Group Management
Allows you to filter and select client groups for your Mail Merge Document. You can choose predefined client groups or create custom groups based on specific criteria such as adviser assignment, service type, review due dates, or client status.
This feature streamlines bulk communication by ensuring documents are only generated for relevant clients.
Access the group management options by selecting the Group Management button from the top right of the Mail Merge window.
Group Management Fields – Explained
Use this field to locate a specific client within your current list using their name or email address. | |
Allows you to search for a previously saved client group. Handy for reusing existing filters or segments. | |
Apply filters based on adviser, client type, status, service, or other criteria to create a targeted group. | |
⛔Unselected Clients | Displays all clients matching your current search or filter criteria who have not yet been selected. |
✅Selected Clients | Shows clients you’ve chosen to include in the mail merge. Move clients from “Unselected” to “Selected” by ticking the checkbox. |
📧Email Column | Displays the client’s primary email address to help confirm identity and ensure accuracy. |
▼Apply Filter | Applies the selected criteria to narrow down the client list for selection. |
📥Save Group | Saves changes made to an existing group (if you're updating a saved group). |
🆕Save as Group | Saves the current selection as a new group for future use. |
❌ Delete Group | Deletes an existing group (use with caution – this action is irreversible). |
🔙Back Button | Returns you to the previous Mail Merge screen without applying changes. |
🔎Search List
Use the search field on the top left of the group management window to search for specific clients.
Search results will show in the unselected clients column. Select the tickbox in front of the client to include in the group. The client will move to the selected client's column.
🔍Search Group
Use the Search Group field in the top right of the window to locate a previously saved group from the dropdown options. Once selected, all associated clients will automatically populate in the Selected Clients column.
☰ Filter Clients
To Filter Clients, use the available filter options located below the search fields.
You can choose from three filter types to refine your client list:
Filter by non-financial client details such as Category, Adviser, Date of Birth, Dependants, or Gender. | |
Filter clients based on financial parameters like Net Worth, Income, or Assets. | |
📝 Custom Filters | Pull data directly from your Custom Fact Find fields, allowing tailored filtering based on your practice-specific requirements.
*Custom Filters are only available if you have created Custom Fact Find Fields |
Selecting the Filter Type will display options specific to that category in the following filter field, allowing you to refine your search based on the selected filter/s.
General Filters | Quick Filters | Is Subscribed to the newsletter Is Between 55 and 56 Is Due for review next month Is an Active Client Has a Photo Saved Is a Primary Client Has no Email Is Business Client Is Not Business Client Includes 'Do Not Contact' |
|
| Adviser | Is | Select from dropdown of available advisers |
| Age Age Next Birthday |
| Enter Age |
| Category | Is | Select a Previously Created Category from drop-down |
| Client Service Manager | Is | Select from dropdown of available staff |
| Date of Birth |
| Enter values or select from drop-down options |
| Dependants |
| Enter values or select from drop-down options where relevant |
| Gender | Is |
|
| Occupation |
| Select from drop-down |
| Referrer |
| Enter values or select from drop-down options |
| Surname |
| Enter values or select from drop-down options |
| Contact Details |
|
*Residency Status
|
| Postcode |
| Enter Values |
| State | Is |
|
| Last Review |
| Choose from pop-out calendars or enter the number * of days |
| Next Review |
| Choose from pop-out calendars or enter the number * of days |
| Review Frequency | Is |
|
| Guardianship |
| Choose from pop-out calendars |
| Power of Attorney |
| Choose from pop-out calendars or drop-down options |
| Will |
| Choose from pop-out calendars, drop-down options or enter values |
| Basic Info Notes | Contain The text | Enter Value |
| Centerlink Number | Is |
|
| Consultants | Are | Enter Value |
| Drivers Licence Number | Is |
|
| First Name |
| Enter Value |
| FSG Version | Is | Select from drop-down |
| Health |
| Select from drop-down |
| Marital Status | Is |
|
| Risk Profile | Is | Select from drop-down of Available Risk Profiles |
| Wedding Date |
| Choose from pop-out calendars or enter values |
| Preferred Contact | Is |
|
Financial Filters | Assets |
| Choose from drop-down options or enter values |
| Expenses |
| Choose from drop-down options or enter values |
| Income |
| Choose from drop-down options or enter values |
| Liabilities |
| Choose from drop-down options or enter values |
| Net Worth |
| Enter Value |
| Superannuation Funds |
| Choose from drop-down options or enter values |
| Insurance Policies |
| Choose from drop-down options or enter values |
| Life Insurance Sum Insured |
| Choose from drop-down options or enter values |
| TPD Insurance Sum Insured |
| Choose from drop-down options or enter values |
| Trauma Insurance Sum Insured |
| Choose from drop-down options or enter values |
| IP Insurance Sum Insured |
| Choose from drop-down options or enter values |
| BE Insurance Sum Insured |
| Choose from drop-down options or enter values |
| FOFA |
| Choose from pop-out calendars or drop-down opti |
📌 Note
The Date Filters are dynamic and automatically update the widget results based on the set date parameters.
👉 For Example
If you configure the filters for a 1-month period, the widget will continuously add new results each day as they meet the criteria.
Refine and Add Multiple Filters
Combining Filters for Accurate Client Searches
To refine your client search results, you can combine multiple filters from General, Financial, or Custom Filters. This allows you to create highly targeted client groups based on specific criteria.
Select a Filter Type:
Choose the filter category you wish to use — General Filters, Financial Filters, or Custom Filters — from the dropdown menu.
Set Filter Conditions
After selecting the filter type, a field of available conditions relevant to that filter will display. Continue refining until no further fields appear.
👉 For example:
General Filters might include age range, adviser, review dates, or marital status.
Financial Filters may include net worth, income, or superannuation balance.
Custom Filters will show any custom fields created in your Fact Find.
Once you select the Apply Filter button, a list of clients matching the chosen conditions will show in the Unselected Clients column, allowing you to review and refine your selection further.
👉 Repeat the process to apply multiple filters.
Each additional filter further narrows the search results, allowing you to focus precisely on clients matching all selected criteria.
📌Note
The more filters you add, the fewer clients will meet the conditions and populate the list—keep this in mind when creating your group.
If clients aren’t appearing in the list, review your filters and double-check the client’s information in Fact Find to ensure they aren’t accidentally excluded.
Once applied, all active filters will display. You can remove or adjust filters as needed by selecting the X at the end of the filter row.
💡Tip
Using multiple filters is ideal for creating targeted client groups, such as clients aged 55+, with upcoming reviews, or holding specific insurance policies.
This process helps generate accurate, meaningful client lists for reports, campaigns, or focused advice delivery.
Review and finalise your client group by previewing the filtered client list. To add clients to your group, tick the checkbox next to each client in the Unselected Clients column.
Alternatively, you can use the master checkbox beside the Client Name heading to select all clients that match your filter criteria. Once selected, these clients will automatically move to the Selected Clients column.
Select Save Group to save it as a new group.
📌Note
You can choose Save As to create variations.
A confirmation prompt will open, allowing you to enter a Group name.
💡 Recommendation
Assign a clear and descriptive name to your Client Group during the final step when prompted—this helps you easily identify it later
Your saved group name will automatically become available in the Select Filter Group
📌Note
Any group you create here will also be available in the Email & SMS sections. Likewise, groups created in the Email and SMS sections will automatically appear in Mail Merge, ensuring consistency across both communication tools.
SMS
📰Create a Document Template
The template functionality in Mail Merge is identical to the Email Templates section, offering a familiar and user-friendly experience.
The editor includes standard word processing tools, allowing you to type directly into the text box, format content, and copy/paste images as needed.
To insert dynamic client/adviser data, select the Insert Code (gear icon) to access dynamic fields—these will populate individual client/adviser information even when generating bulk documents.
⚠️Important⚠️
Your address details and logo will not automatically populate in a Mail Merge template as they do in advice documents.
👉 To include your business header, you can manually insert your logo as an image and use dynamic fields to display address and contact details, ensuring your template remains on-brand.
📌Note
You can also apply your practice’s saved templates during the Microsoft Word editing stage, allowing you to maintain consistency in branding, formatting, and structure across all client communications.
Once you've created your template, select Save. You'll be prompted to enter a template name and choose a template category from the drop-down menu to help organise and manage your templates effectively.
You will be prompted to enter the Template Name and select the Template Category.
Select the previously created Template Category from the category dropdown.
Select OK to save your template.
📌Note
You can save a template without assigning a category; however, it is recommended to categorise templates to keep them organised and easy to locate — especially when managing multiple templates across teams or advice types.
🗃️Creating Category -
Using the Add Category Window to Create and Manage Categories
To create and manage Template Categories, select the Template field from the top left of the main window.
Select the Add Category button from the top left of the Template Manager screen.
The Add Category window allows you to create and manage template categories to keep your Mail Merge templates organised and easy to access.
Add a New Category
In the Category Name field at the bottom of the window, type the name of your new category (e.g., “Review Letters” or “Fee Disclosure”).
Select Save to add the new category to the list.
The category will now show in the category list.
Managing Existing Categories
✏️Edit
Select the green pencil icon next to an existing category to rename it.
🗑️Delete
Select the red bin icon to permanently remove a category.
📌Note
Deleting a category does not delete the templates within it, but they will become uncategorised.
👉Tips for categorising templates:
Use clear, purpose-driven names (e.g., “Client Engagement”, “Advice Pack”, “Welcome Pack”) to make templates easier to locate.
Categories are shared across both the Mail Merge and Email template libraries.
🗂️Manage Templates
To access the Template Management options, select the Template button from the top left of the Mail Merge main window.
The Templates window will open, displaying a list of your saved Mail Merge templates.
Here, you can view each template’s associated category (if assigned).
Use the View Categories link to expand and view the category associated with a template.
You can also access key template management options:
✏️Edit Template | Opens the template for editing. You can update the content and formatting. |
📑Duplicate Template | Creates a copy of the selected template for reuse or modification. |
🗑️Delete Template | Permanently deletes the template. Use with caution—this action cannot be undone. |
➦Send/Share Template | Shares the template with other users or makes it available across the practice. |
Use the Add Category button in the top right to create and manage categories.
📥Generate Document
Select Template
To generate a document, select the Template from the template dropdown at the top of the mail merge window next to the Template button.
Select Client/Group
Selecting the To button from the Mail Merge screen will open the client selection window. Allowing you to specify the clients for whom you wish to generate documents.
You can manually enter client names, choose from a list, or apply filters to add multiple clients at once. Alternatively, use the Select Group drop-down to choose from a previously saved client group for bulk document generation.
The Send To window allows you to select the clients for whom you want to generate personalised Mail Merge documents.
Search List | Use this field to manually search for individual clients by name or keyword. |
Select Group | Choose from a list of previously saved client groups for bulk document generation. |
Filter Clients | Apply filters to refine your client list based on various criteria (e.g., adviser, status, category). |
Client List | Displays the results based on your search or filters. Each row includes the client’s name and email address. |
Checkboxes | Tick individual checkboxes to select clients, or use the header checkbox to select all visible clients. |
Apply Filter | Click to apply the selected filter settings and refresh the client list. |
OK Button | Once your client selection is complete, select OK to return to the main Mail Merge screen with your selected recipients. |
Generate Template
Once you’ve selected your template and added the relevant clients, select the Generate button.
A confirmation window will appear, prompting you to create a File Note against the selected clients’ records.
⚠️Important⚠️
Mail Merge does not send emails. It only produces a document based on the selected template and client data.
All clients will appear in the mail merge, whether they have email addresses saved or not in their contact details section.
A personalised letter will be generated for each client who meets the selected conditions, with all dynamic fields automatically populated from the data in your template.
All letters are compiled into a single Microsoft Word document, with each client’s letter separated by a page break. This consolidated format is designed for efficiency and ease of bulk printing or reviewing.
If you need to split the merged document into individual files for emailing or record-keeping, you can do so using one of the following methods.
📄How to Split a Mail Merge Document into Individual PDFs
Option 1 - Use Microsoft Word’s “Finish & Merge” Feature
(Recommended if you're working directly in Word)
Open your Mail Merge template in Microsoft Word. Navigate to the Mailings tab.
Use the Microsoft Mail Merge functions within the document
Select the document type from the Start Mail merge Option , assign the recipient list Select Finish & Merge > Edit Individual Documents.
Choose All (or specify a range) in the dialogue box. Click OK to generate a new Word file with each letter on a separate page.
This allows you to save or modify each letter as needed before printing or exporting.
Option 2 - Save Individual PDFs Manually
(Ideal for small batches)
From the merged Word document, go to File > Print. Set the printer to Microsoft Print to PDF.
Under Pages, enter the range for the client (e.g., 1–1). Select Print, then save the file using the client’s name.
Option 3 - Use a Third-Party Tool
(Recommended for bulk document splitting)
Use tools like:
PDFsam (free and open source)
Adobe Acrobat Pro
Kutools for Word (add-in for mail merge splitting)
📌Note
AdviserLogic does not specifically endorse or recommend any of the third-party providers listed above. They are included as examples only to illustrate possible solutions for splitting merged documents.
These tools can:
Automatically split by page or section
Name files using merge fields (e.g., {{Client.FullName}})
Export all documents to a specified folder in just a few clicks