Preparing a Mail Merge

Preparing a Mail Merge


InfoThis article is part of the Mail Merge section.

Find all related articles here:
Mail Merge
 
Alert
Before starting a mail merge, make sure the template is closed.

Info
The first step in running a mail merge is to prepare it by selecting the template and choosing the recipients.

First Steps


You can start a mail merge in several ways:
    1. Go to Documents > Send Out in the top menu.
    2. Open a Client Account > go to the Letters Documents tab > click Send in the action panel on the left.
      1. This option is used to send the communication to one client.
    3. Open a PL Account > go to the Letters Documents tab > click Send in the action panel on the left.
      1. This option is used to send the communication to one purchase ledger account.

This opens the Documents: Distribute window.

The window consists of three sections:
    1. Template, audience and further distribution options are on the left.
      1. Read about the distribution options in the Additional Options section further down.

    2. Recipient filter options in the middle, which update based on the selected Distribute Type.

    3. The recipient list on the right, which updates based on the filters you set.

The action buttons are at the bottom of the window.

Locating the Template


  1. Select the Distribute Type from the drop-down menu, matching the Document Module Type used when saving the template.
Idea
To narrow down the template list, use the search box under Template.
  1. Next:
    1. Click on the template you wish to use to highlight it.
    2. Add a description.
    3. Choose the Sent From user.
      1. This defaults to the current user but can be changed if you want someone else to send the communication:



Adding Recipients


You can add recipients in two ways:
  1. Use the filter options in the middle section, then select from the list of recipients shown in the column on the right.
  2. Upload a list of recipients if you're distributing the document to clients.

Adding Recipients Using the Recipient Filter


In the Documents: Distribute window, the recipient filter will appear based on the selected Distribute Type (e.g. selecting Client will show the Clients Filter).

Each filter offers different options to narrow the recipient list. The Client filter provides the most criteria, including:
  1. Client status (all, current or exited)
  2. Property manager
  3. Account details
  4. Various ranges (dates, developments)
You can select multiple criteria at once.
  1. Additional filters may appear based on your selections.
  2. For example, Development Range, which allows you to filter by:
    1. development,
    2. property,
    3. block,
    4. or apportionment.

Scroll down the sidebar to view all available options:



After selecting your criteria, click Get Recipients at the bottom to display the filtered list:



The list of recipients will appear in the column on the right. Select all by ticking the box at the top, or choose individual recipients:



Info
If recipients have opted for email, you’ll see a tick in the Emailed column. If not, the communication will be printed for mailing.

Adding Recipients by Uploading Client Account Numbers


Alternatively, you can upload a list of recipients by:
  1. Entering client account numbers into a .csv file:



  2. Uploading it using the Get Recipients From Account Number CSV button:





Alert
If any account number starts with a 0, format the column as Text to preserve the leading zero.

Additional Options


Selecting the Audience (Optional)


If you use the Web Portal and the Client App, you can share the communication with your clients in the Portal and the App. To do this, adjust the Audience Filters as follows:

  1. Choose the Type to specify WHO will see the communication in the Web Portal. Some types reveal additional options for further narrowing down the audience.

    1. Selecting Development shows a drop-down list where you can choose a specific development.
      1. Clients in that development will see the communication.

    2. Selecting Client and then Development lets you choose a specific client within a development.
      1. Only that client will see the communication.

    3. Selecting Development Diarised Charges allows you to choose a development and a diarised charge.
      1. Clients assigned to that charge will see the communication.

  2. Choose the Web Type to specify WHERE the communication will appear in the Documents tab of the Portal/App.
    1. The section you select from the drop-down will determine where the document is shown.

  3. In the example below, clients in Block 1 , Development 0001 will see the communication under the Development Letter section of the Web Portal's Documents tab:



Selecting the Important box will add a checkmark in the Important column on the Letters Documents tab of the client account.
  1. Important documents will be displayed first, at the top of the list.

Alert
If you don't use the Web Portal and Client App, leave the Audience Type set to Private (Account Only) and the Web Type set to --SELECT--.

Alert
Be cautious when selecting the Audience Type. If unsure, choose Private (Account Only) to restrict the communication to the client account(s) involved. For example, if you select Development as the Audience Type while sending the communication to only one client, the communication will be visible to all clients in that development in the Documents tab in the Portal.

Distribution Tools (Optional)


Use the Distribution Tools options to override recipient email settings, preview the final result, or use a template not uploaded into CPL.

Click Show Tools under Distribution Tools to reveal the options:
  1. Email Override:

    1. Default: Uses the client account’s email settings. If an email address is provided and the For Documents box is ticked, the communication will be emailed.

    2. Print Only: Even if the client has an email address and For Documents is ticked, the communication will be printed and not emailed.

    3. Print and Send: The communication will be printed, but if the client has an email address and For Documents is ticked, it will also be emailed.

  2. Preview PDF:
    1. Check this box and click Preview PDF to preview the final version of the communication as clients will see it.
    2. For example, it will show how signatures will appear when a mail merge field like InspectorSignaturePath is inserted.
    3. The preview will display the image, while the mail merge process will show the file path.



  3. Use Ad-Hoc Template: 
    1. Check this box to use a template not uploaded into CPL.
    2. Click Print/Send or Generate Documents as usual. 
    3. A window opens where you can browse for the file on your PC or network.
    4. Highlight the file and click Open.
    5. The rest of the process is the same.

Idea
Select both Preview PDF and Use Ad-Hoc Template to preview a template not uploaded into CPL.
This is only a preview. To process the ad-hoc template, remove the Preview PDF tick and click Print/Send or Generate Documents.

Idea
You might want to revisit the description of the Preview PDF and and Use Ad-Hoc Template options when running the mail merge.

    • Related Articles

    • Mail Merge Fields

      This article is part of the Mail Merge section. Find all related articles here: Mail Merge When editing a template during a mail merge, make sure that you use fields from only one View/Table. If you're sending the template as-is, you can use mail ...

    • Running a Mail Merge

      This article is part of the Mail Merge section. Find all related articles here: Mail Merge Before starting a mail merge, make sure the template is closed. Here, we've covered how to prepare a mail merge. Now, let's focus on running it. To run a mail ...

    • Mail Merge Fields

      Please click on the image below to access the Helpsheet for Non-Azure Clients Mail Merge Fields in CPL.

    • Getting Started with Mail Merge

      This article is part of the Mail Merge section. Find all related articles here: Mail Merge Mail merges in CPL are used for creating and sending documents to clients and contractors. They let you build templates that can be automatically personalised ...

    • Uploading Mail Merge Templates into CPL

      This article is part of the Mail Merge section. Find all related articles here: Mail Merge To make your mail merge template available to all CPL users, add it to the Templates directory: Go to the System menu at the top of the main window. Select ...