Running a Mail Merge

Running a Mail Merge

InfoThis article is part of the Mail Merge section.

Find all related articles here:
 
Alert
Before starting a mail merge, make sure the template you intend to use is closed.

Info
Here, we've covered how to prepare a mail merge. Now, let's focus on running it.

You can run mail merges in three ways:
  1. Send the communication by post and/or email using a template.
  2. Send the communication by email without using a template.
  3. Generate the documents without sending them, and make them available in the Web Portal if needed.

Idea
Before generating or sending the documents, the Preview PDF and Use Ad-Hoc Template options may be useful, as described here.

After you've prepared your mail merge as outlined here, follow the below steps to generate or generate and send your communication:

Sending the Communication Using a Template


Alert
If you use an external printing service, follow this article for instructions on how to send your communication to the provider.

  1.  Click Print/Send:



  2. A window will open allowing you to attach additional files to your communication:
    1. Click OK to continue without adding files.
    2. If you do want to attach files:
      1. To attach a file, click Add.
      2. To remove a file, click Remove.
      3. Click OK when you're done.


  1. A progress bar will appear:


  1. A pop-up message will appear. Don't click OK yet:



  2. The Word template opens in the background. Click its icon in the taskbar to bring it forward.

  3. Review the template and make any necessary adjustments.
    1. You can add more text and mail merge fields, just like when  creating a template. 
      1. Learn more about adding mail merge fields here and here.
    2. For multiple recipients:
      1. Use the arrows in the Mailings tab to navigate between them.
      2. Click Find Recipient to search for a specific client:



Alert
When copying and pasting text, ensure it's in plain format. If copying from another source, first paste it into Notepad to remove hidden formatting, then copy it back into the template.

  1. When ready, return to the pop-up and click OK.
    1. Click Yes on the next prompt that appears:



    1. The progress bar will show both the number of prints and emails, along with the stages of the process.
      1. Once complete, a pop-up message and the progress bar will confirm the mail merge is done.
      2. The batch number will also be shown:


  1. Clients who have opted for email will receive their communication via email.

  2. Clients who haven't opted for email will have their documents sent to your printer.

  3. The communication has been sent and a copy is saved in the Letters Documents tab of the recipients' accounts.

Notes
If you added attachments and some recipients don’t use email, the attachments will be saved on the Letters Documents tab only if the system option "Document Mail Merge Save Attachments For Printed" is turned on.

Sending the Communication Without Using a Template


You can choose to bypass the selected template and not use one at all during the mail merge.

After selecting your recipients, follow these steps:
  1. Click Email/SMS (Note: SMS functionality is not available):

  1. The Correspondence Wizard will open on the From screen.
    1. Select the email sender: the email address set up in your CPL user or the company email address.
    2. Select a signature from the Signature drop-down or type a custom one in the box below:



  2. Click Next.

  3. Add a subject, customise the email body and click Next:



  4. Click the plus sign to add attachments (optional) or the minus sign to remove them. Click Next:



  5. The first letters of the email addresses and client accounts to receive an email will appear as Queued. The total number of emails will be shown in the bottom-left corner. Click Finish to send the emails:



  1. Click Yes in the pop-up to confirm you want to send the emails:



  2. The system will begin sending the emails and Queued will change to Sent as each email is sent.
    1. Once finished, confirm the "Correspondence complete" pop-up and click Finish:



  3. The emails will be added to the Letters Documents tab of the relevant client accounts.

Generating Documents Only


To generate the documents without emailing or printing, click Generate Documents instead of Print/Send. The documents will be added to the Letters Documents tab of the relevant accounts:



If you set the Audience Type and Web Type, the documents will also appear in the Web Portal. Read more about this here.





    • Related Articles

    • Preparing 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. The first steps in running a mail merge are preparing the template and selecting recipients. ...
    • 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, use fields from only one View/Table. Here are the mail merge fields available for your templates: With the add-in, ...
    • Sending Mail Merge Communications to External Print Providers

      This article is part of the Mail Merge section. Find all related articles here: Mail Merge If you're sending documents to an external printing service, follow these steps to send your communication when running a mail merge: Click Print/Send: A ...
    • Fixing Certificate Errors During Mail Merge Word Add-In Installation

      This article is part of the Mail Merge section. Find all related articles here: Mail Merge If you come across a certificate error saying "There was an error during installation" while installing the Word add-in for mail merges, you will need to: Run ...
    • Installing the Mail Merge Add-In for Word

      This article is part of the Mail Merge section. Find all related articles here: Mail Merge When creating mail merges with CPL and Microsoft Word, the mail merge add-in simplifies the process. This guide outlines the steps to install the add-in: Log ...