<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE concept PUBLIC "-//OASIS//DTD DITA Concept//EN" "../dtd/concept.dtd">
<concept id="mail-merge-guide" xml:lang="en-us">
  <title>Mail Merge guide</title>
  <shortdesc>Use Mail Merge to create personalized signature requests in bulk by preparing a Microsoft Word template, building a CSV file, and sending documents through the Mail Merge Wizard.</shortdesc>
  <conbody>
    <p outputclass="openallaccordions">Show all hidden content.</p>
    <p>Mail Merge is a desktop application designed to send personalized letters for signature to a larger number of recipients than Signatures typically allows. This program requires Microsoft Word. Once installed, you can create templates and mailing lists to deliver documents like engagement letters in bulk.</p>
    <note>As of April 27, 2024, users can sign in to Mail Merge using Office 365/Single Sign-On. This must be enabled in <uicontrol>Product Settings</uicontrol>.</note>
    <section id="download-mail-merge">
      <title>Download Mail Merge</title>
      <p>The Mail Merge download process installs a desktop application and a Microsoft Word plugin.</p>
      <note>
        <ul>
          <li>The Mail Merge app must be downloaded by a System Admin from <uicontrol>Product Settings</uicontrol>.</li>
          <li>This app and Microsoft Word must be installed locally on each user's PC.
            <ul>
              <li>Don’t install from OneDrive or an external drive.</li>
            </ul>
          </li>
          <li>Mail Merge is not compatible with terminal server environments.</li>
        </ul>
      </note>
      <ol>
        <li>Select the <uicontrol>Navigation Widget</uicontrol>.</li>
        <li>Select <uicontrol>Product Settings</uicontrol>.</li>
        <li>Select <uicontrol>Download</uicontrol> under <menucascade>
          <uicontrol>General</uicontrol>
          <uicontrol>Product Downloads</uicontrol>
          <uicontrol>Mail Merge</uicontrol>
          </menucascade>.</li>
        <li>Run the downloaded <uicontrol>MailMerge.exe</uicontrol> file.</li>
        <li>Let the app make changes to your device to open the <uicontrol>Mail Merge Setup</uicontrol> window.</li>
        <li>Select <uicontrol>Next</uicontrol>.</li>
        <li>Select <uicontrol>Agree</uicontrol> in the <uicontrol>License Agreement</uicontrol> window.</li>
        <li>Select <uicontrol>Install</uicontrol> in the <uicontrol>Choose Install Location</uicontrol> window.</li>
        <li>Select <uicontrol>Finish</uicontrol> in the <uicontrol>Completing Mail Merge Setup</uicontrol> window.</li>
        <li>Enter a username and password, then select <uicontrol>Login</uicontrol>, or select <uicontrol>Continue with Office365</uicontrol>.</li>
      </ol>
    </section>
    <section id="creating-word-template">
      <title>Creating a Microsoft Word template</title>
      <p>Once Mail Merge is installed, Microsoft Word has an <uicontrol>E-Sign Action Center</uicontrol> plugin that is used to generate a Mail Merge template.</p>
      <note>
        <p>Don’t anchor images or signature blocks to the page. Editing the layout of the signature blocks can disrupt the signature block function or cause the Mail Merge app to crash.</p>
      </note>
      <ol>
        <li>Select <uicontrol>Create Document Template</uicontrol> from the Mail Merge desktop application, or open Microsoft Word.</li>
        <li>Select <uicontrol>SafeSend Signatures</uicontrol>.</li>
        <li>Select <uicontrol>E-Sign Action Center</uicontrol>.</li>
        <li>Use the <uicontrol>SafeSend Signatures</uicontrol> window to place signature blocks, merge fields, and generate a CSV template as the following outline.</li>
      </ol>
    </section>
    <section id="signature-placement">
      <title>Signature Placement</title>
      <p>The <uicontrol>Signature Placement</uicontrol> tab shows client action items. The signer is prompted to fill these fields if they are added to the template. One exception is the date field, which is auto-filled.</p>
      <p>To add fields to the form, follow these steps:</p>
      <ol>
        <li>Place your cursor in the document where a signature field is needed.</li>
        <li>Select the <uicontrol>Signer</uicontrol> dropdown to select which signer will fill the field.
          <ul>
            <li>The item you are placing can only be completed by the designated signer.</li>
          </ul>
        </li>
        <li>Double-click the signature field to place it.</li>
        <li>Type a <uicontrol>Tooltip</uicontrol> in the <uicontrol>Data Field</uicontrol> checkbox if using a data field.
          <ul>
            <li>The signer can enter free text in this checkbox. The tooltip tells them what information is being requested.</li>
          </ul>
        </li>
        <li>Ensure the field is marked as <uicontrol>Required</uicontrol> if you want it to be required.
          <ul>
            <li>Double-click a placed field to confirm whether it is marked as required.</li>
          </ul>
        </li>
      </ol>
      <p>The same template can be used regardless of the number of signers. Mail Merge recognizes the number of email addresses, or signers, in the CSV file.</p>
    </section>
    <section id="conditional-controls">
      <title>Conditional Controls</title>
      <p>When adding <uicontrol>checkboxes</uicontrol> or <uicontrol>radio buttons</uicontrol>, you can create conditional rules for those buttons.</p>
      <p>For example, if option A is selected, the signer signs one field. If option B is selected, the signer initials another field.</p>
      <ol>
        <li>Select the signer.
          <ul>
            <li>This is the recipient who will be prompted to fill in the field.</li>
          </ul>
        </li>
        <li>Place your cursor in the document where an item is needed.</li>
        <li>Double-click the radio button or checkbox option to add it to the page.</li>
        <li>Enter how many buttons to add.
          <ul>
            <li>Additional options appear in the right panel after the selection has been added.</li>
          </ul>
        </li>
        <li>Drag and drop the button to move it to the correct position.</li>
        <li>Select whether the client is required to complete the field.</li>
        <li>Select <uicontrol>Select field from page</uicontrol>.</li>
        <li>Select the signature field to reveal when that option is selected.
          <ul>
            <li>It is added to the <uicontrol>Then</uicontrol> options in the right panel.</li>
          </ul>
        </li>
        <li>Select <uicontrol>Save Rule</uicontrol> to save your changes.</li>
      </ol>
    </section>
    <section id="mail-merge-tab">
      <title>Mail Merge tab</title>
      <p>The <uicontrol>Mail Merge</uicontrol> tab lets you place merge fields into the template. Data is pulled from the CSV template to auto-fill those fields.</p>
      <p>There are three predefined merge fields:</p>
      <ul>
        <li>TaxpayerName</li>
        <li>Salutation</li>
        <li>Client ID</li>
      </ul>
      <p>All other fields are created using the <uicontrol>Create Custom Merge Fields</uicontrol> tool.</p>
      <p>Each merge field corresponds to a column header in the CSV file. There is no limit to the number of merge fields that can be added.</p>
    </section>
    <section id="create-and-place-merge-fields">
      <title>Create and Place Merge Fields</title>
      <ol>
        <li>Place your cursor in the document where an item is needed.</li>
        <li>Double-click a merge field to place it, or select <uicontrol>Create Custom Merge Fields</uicontrol>.</li>
        <li>Type a merge field name in the field.
          <ul>
            <li>Spaces are removed.</li>
            <li>Don’t add special characters to the merge field name.</li>
          </ul>
        </li>
        <li>Select <uicontrol>Place Field</uicontrol>.
          <ul>
            <li>The field is saved if it is needed again for that document.</li>
          </ul>
        </li>
      </ol>
    </section>
    <section id="creating-csv-file">
      <title>Creating a CSV File</title>
      <p>Once all necessary merge fields have been placed, you can create a corresponding spreadsheet. Each <uicontrol>Merge Field</uicontrol> is a column header in the spreadsheet.</p>
      <note>
        <ul>
          <li>Microsoft Excel automatically deletes leading zeros. </li>
          <li>Individual cells don’t have character limits. Full paragraphs or more can be entered in these cells.</li>
          <li>If a cell is left blank in the CSV file, that field is removed from the Microsoft Word template, and spacing is adjusted to normalize formatting.</li>
          <li><uicontrol>SignerXEmail</uicontrol> and <uicontrol>SignerXName</uicontrol> are required. Other columns can be left blank.</li>
        </ul>
      </note>
      <ol>
        <li>Select <uicontrol>Create CSV Template</uicontrol>.</li>
        <li>Fill in the required information.
          <ul>
            <li>Signer emails</li>
            <li>Signer names</li>
          </ul>
        </li>
        <li>Fill in all other merge fields as needed.</li>
        <li>Ensure the <uicontrol>Version</uicontrol> number is in place.</li>
        <li>Save and close the file.
          <ul>
            <li>The file can't be open when you process the batch from the app.</li>
          </ul>
        </li>
      </ol>
    </section>
    <section id="using-mail-merge-wizard">
      <title>Using the Mail Merge Wizard</title>
      <p>Once the Microsoft Word template and CSV file are completed, the batch of documents can be delivered for eSignature with the Mail Merge Wizard. There are five steps to batch process and send documents for eSignature. Open the <uicontrol>Mail Merge</uicontrol> desktop application to get started.</p>
    </section>
    <section id="step-1-select-files">
      <title>Step 1: Select Files</title>
      <p>The documents must be saved and closed before beginning.</p>
      <ol>
        <li>Select <uicontrol>Open Document Template</uicontrol> to upload the Microsoft Word template.</li>
        <li>Select <uicontrol>CSV FILE</uicontrol> to upload the corresponding CSV file.
          <ul>
            <li>The document name appears at the bottom of each checkbox once uploaded.</li>
          </ul>
        </li>
        <li>Select <uicontrol>Step 2: Check Errors</uicontrol>.</li>
      </ol>
    </section>
    <section id="step-2-check-errors">
      <title>Step 2: Check errors</title>
      <p>During Step 2, the Mail Merge Wizard verifies that the selected files can be successfully merged.</p>
      <p>If there are errors:</p>
      <ol>
        <li>Review the detailed error description.</li>
        <li>Select <uicontrol>Select Files</uicontrol>.</li>
        <li>Correct any errors in the Microsoft Word template and CSV file.</li>
        <li>Reupload the corrected templates.</li>
      </ol>
      <p>If there are no errors:</p>
      <ol>
        <li>Select <uicontrol>Step 3: Merge Files</uicontrol>.</li>
      </ol>
    </section>
    <section id="step-3-merge-files">
      <title>Step 3: Merge Files</title>
      <p>Step 3 merges the files.</p>
      <ol>
        <li>View the progress bar.
          <ul>
            <li>You can go away from this window to let it work in the background.</li>
            <li>Once complete, a window showing all documents opens.</li>
          </ul>
        </li>
        <li>View the <uicontrol>Document Name</uicontrol>.
          <ul>
            <li>All documents show the Microsoft Word file name.</li>
            <li>Double-click the document name to preview the file.</li>
          </ul>
        </li>
        <li>View the Signer 1 <uicontrol>E-Mail</uicontrol> addresses.</li>
        <li>Select <uicontrol>Step 4: Configuration</uicontrol>.</li>
      </ol>
    </section>
    <section id="step-4-configuration">
      <title>Step 4: Configuration</title>
      <p>Step 4 lets you select settings and add or edit the message sent to document recipients. Default settings are auto-filled based on your firm settings.</p>
      <note>Firm settings can allow or restrict editing during the <uicontrol>Configuration</uicontrol> step.</note>
      <ol>
        <li>Select the <uicontrol>Document Type</uicontrol>.</li>
        <li>Adjust the <uicontrol>Expiry Date</uicontrol> as necessary.</li>
        <li>Select a <uicontrol>Tax Year</uicontrol>.</li>
        <li>Select the <uicontrol>Sender Signing Order</uicontrol> if a Sender Signature block was included in the Microsoft Word document.</li>
        <li>Select an <uicontrol>Office Location</uicontrol>.</li>
        <li>Select a <uicontrol>Contact Person</uicontrol> for the signer or signers to contact.</li>
        <li>Select a <uicontrol>Signing Sequence</uicontrol>.
          <ul>
            <li><uicontrol>Parallel Signing</uicontrol> lets all signers sign at the same time.</li>
            <li><uicontrol>Custom Signing Sequence</uicontrol> requires clients to sign in order. Signer 2 doesn’t receive an access link until Signer 1 completes signing.</li>
          </ul>
        </li>
        <li>Select a <uicontrol>Message</uicontrol> template or create a new <uicontrol>Message</uicontrol>.
          <ul>
            <li>If you create a new message, clear formatting from the subject and message when pasting. You can do this by typing it manually or pressing Ctrl + Shift + V.</li>
          </ul>
        </li>
        <li>Select <uicontrol>Access Code Required</uicontrol> to add an additional layer of security.
          <ul>
            <li>The document recipient must enter an access code sent to their email address before viewing or signing.</li>
          </ul>
        </li>
        <li>Select <uicontrol>Step 5: Send for Signature</uicontrol>.</li>
      </ol>
    </section>
    <section id="step-5-send-for-signature">
      <title>Step 5: Send for signature</title>
      <p>The document is delivered to all designated recipients. Delivered items appear in the Delivered section of Signatures.</p>
      <ol>
        <li>View the progress bar.
          <ul>
            <li>You can go away from this window to let it work in the background.</li>
            <li>Once completed, Step 1 of the Mail Merge Wizard displays.</li>
          </ul>
        </li>
        <li>Locate Mail Merge items in the Delivered report in Signatures.</li>
      </ol>
    </section>
  </conbody>
</concept>