Skip to main content

How to Use Mail Merge to Create Letter Templates

Learn how to generate personalised client documents using Mail Merge in AdviserLogic with Microsoft Word — efficient, accurate, and branded

Maria Iglesias - Content Lead avatar
Written by Maria Iglesias - Content Lead
Updated over a week ago

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

  • Is

  • Less than

  • Greater than

  • Between

  • Not Between

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

  • Between

  • Before

  • After

  • In the Month of

  • In the Years of

  • Last (in Days)

  • Next (in Days)

Enter values or select from drop-down options

Dependants

  • Exist

  • Do Not Exist

  • Are Younger Than

  • Are Older Than

  • Are between the Ages Of

Enter values or select from drop-down options where relevant

Gender

Is

  • Male

  • Female

Occupation

  • Is

  • Is Not

Select from drop-down

Referrer

  • Is

  • Is Not

  • Contains the text

Enter values or select from drop-down options

Surname

  • Is

  • Containing the Word

  • Not Containing the Word

Enter values or select from drop-down options

Contact Details

  • Has a home phone

  • Has a Mobile number

  • *Has a residency status of

  • Has a work phone

  • Has a work email

  • Has a home email

  • Stored in AdviserLogic

  • Not Stored in AdviserLogic

*Residency Status

  • Australian Resident

  • Not Australian Resident

Postcode

  • Between

  • Is

  • Not Between

Enter Values

State

Is

  • NSW

  • QLD

  • VIC

  • SA

  • WA

  • TAS

  • NT

  • ACT

  • Other

Last Review

  • Was Before

  • Was After

  • Was Bewteen

  • *Next (in Days)

  • *Last (in Days)

Choose from pop-out calendars or enter the number

* of days

Next Review

  • Is

  • Before

  • After

  • Between

  • In the Month of

  • Last (in Days)

  • Next (in Days

Choose from pop-out calendars or enter the number

* of days

Review Frequency

Is

  • Yearly

  • Quarterly

  • Monthly

  • Fortnightly

  • Weekly

  • Half Yearly

  • Single

  • Triannual

  • 2 Year

  • BiMonthly

  • Four Weekly

  • 3 Year

Guardianship

  • Is

  • Before

  • After

  • Between

Choose from pop-out calendars

Power of Attorney

  • Is

  • Before

  • After

  • Between

  • Has a Type of

  • Last (in Days)

  • Next (in Days

Choose from pop-out calendars or drop-down options

Will

  • Is

  • Before

  • After

  • Between

  • Is in the Location of

  • Has a Testamentary Trust

  • Last (in Days)

  • Next (in Days)

Choose from pop-out calendars, drop-down options or enter values

Basic Info Notes

Contain The text

Enter Value

Centerlink Number

Is

  • Stored in AdviserLogic

  • Not Stored in AdviserLogic

Consultants

Are

Enter Value

Drivers Licence Number

Is

  • Stored in AdviserLogic

  • Not Stored in AdviserLogic

First Name

  • Is

  • Containing the word

Enter Value

FSG Version

Is

Select from drop-down

Health

  • Is

  • Health Insurance is

  • Has a Smoker Staus of

Select from drop-down

Marital Status

Is

  • Married

  • Single

  • Widowed

  • Divorced

  • Separated

  • Defacto

  • Engaged

  • Partner

Risk Profile

Is

Select from drop-down of Available Risk Profiles

Wedding Date

  • Was (Years Ago)

  • Was before

  • Was after

  • Was between

  • Was in the month of

  • Last (in Days)

  • Next (in Days)

Choose from pop-out calendars or enter values

Preferred Contact

Is

  • Phone

  • Email

  • Mail

Financial Filters

Assets

  • Have a Description of

  • Are of the Type

  • Have a value greater than

  • have a value between

  • Have the ASX code

  • Have the APIR code

  • Are of the platform

Choose from drop-down options or enter values

Expenses

  • Greater than

  • Less than

  • Between

  • Include the type

Choose from drop-down options or enter values

Income

  • Greater than

  • Less than

  • Between

Choose from drop-down options or enter values

Liabilities

  • Have a value greater than

  • Have a value less than

  • Have a value between

  • Are of the type

  • Are from the lender

Choose from drop-down options or enter values

Net Worth

  • Greater than

  • Less than

  • Between

Enter Value

Superannuation Funds

  • Are of the type

  • Are of the platform

  • Are in the phase of

  • Have a value greater than

  • Have a value less than

  • Have a value between

  • Have an estate option of

  • Are making contributions of the type

Choose from drop-down options or enter values

Insurance Policies

  • Have the Insurer

  • Have a total annual premium greater than

  • Have a total annual premium less than

  • Have a total annual premium between

  • Have an issue date before

  • Have an issue date after

  • Have an issue date between

  • Have an issue date in the month of

  • Have a next review date before

  • Have a next review date after

  • Have a next review date between

  • Have a next review date in the month of

  • Have a smoker status of

  • Have child policies

  • Have a premium frequency of

  • Have a premium due

  • Has Insurance Policies

Choose from drop-down options or enter values

Life Insurance Sum Insured

  • Is

  • Greater than

  • Less than

  • Between

Choose from drop-down options or enter values

TPD Insurance Sum Insured

  • Is

  • Greater than

  • Less than

  • Between

Choose from drop-down options or enter values

Trauma Insurance Sum Insured

  • Is

  • Greater than

  • Less than

  • Between

Choose from drop-down options or enter values

IP Insurance Sum Insured

  • Is

  • Greater than

  • Less than

  • Between

Choose from drop-down options or enter values

BE Insurance Sum Insured

  • Is

  • Greater than

  • Less than

  • Between

Choose from drop-down options or enter values

FOFA

  • Service Level

  • Application Date

  • Disclosure Date

  • Opt-In Renewal Date

  • Opt-In Renewal End

  • Termination Date

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.

Email

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


Did this answer your question?