Guide to using ODS-Mail for Mail Merge

What is it?

ODS-Mail has an "Email Merge" feature that enables dynamic email message construction, merging content with data from:

These "merge-sources" may be local or remote HTTP-accessible files, including SPARQL SELECT Queries which deliver CSV-formatted output.

Why is this important?

Just as printed mail merges once did, this provides a productive mechanism by which to generate email messages to dispatch information, on a highly focused basis, to relevant contacts.

How do I use it?

Step 1 - Prepare Recipient List

Create or locate your recipient list ("merge-source" document), in any supported format --

Step 2 - Prepare Merge Template

  1. Go to the ODS-Mail application home page:



  2. Drill down to Preferences -> Templates:



  3. Click Create for a new Template, or click Edit to work with an existing one:



    • ODS-Mail supports merge placeholders only in the To: and Subject: headers, and the message body.
    • Wrap placeholder strings in double-braces (e.g., {{place holder}}) to indicate content merge insertion points.
    • If you can, use placeholder strings that match the field names you've used in your merge source. Don't worry if you don't know what those names are yet -- during the mail merge process, you will be prompted to set up a manual mapping between any unrecognized template placeholders and the fields in your merge-source.
    • ODS-Mail supports a number of default template placeholders, which follow the other conventions for field mapping in ODS. If your placeholders have other names, then you will be prompted to provide a mapping for this merge.
      • {{Title}}
      • {{First Name}}
      • {{Middle Name}}
      • {{Last Name}}
      • {{Gender}}
      • {{Birthday}}
      • {{Company}}
      • {{Job Title}}
      • {{Home Street}}
      • {{Home Street 2}}
      • {{Home City}}
      • {{Home State}}
      • {{Home Postal Code}}
      • {{Home Country}}
      • {{Home Phone}}
      • {{Home Fax}}
      • {{E-mail Address}}
    • Due to nuances of Web browser, Web server, Mail server, and Mail client interaction, you may want to test with a simple merge to only yourself, to ensure that all content is delivered as intended. For example:
      • In the "To:" header --

        To: "{{name}}" <{{mbox}}>

        -- will preview and be output as the SMTP-deliverable --

        To: Fred Jones fjones@example.com

        -- while --

        To: &quot;{{name}}&quot; &lt;{{mbox}}&gt;

        -- will preview as --

        To: "Fred Jones" <fjones@example.com>

        -- but be output as the SMTP-undeliverable --

        To: &quot;Fred Jones&quot; &lt;fjones@example.com&gt;

      • In the Body --

        Dear {{firstname}},

        -- will render as --

        Dear Fred,

      • In the Body --

        &quot;&#123;&#123;firstname&#125;&#125; &#123;&#123;lastName&#125;&#125;&quot; &lt;&#123;&#123;mbox&#125;&#125;&gt;

        -- will render as --

        "Fred Jones" <fjones@example.com>

  4. Click Save to preserve your changes. Note: When creating a new template, you will only have a Save button, until you do so. When editing an existing template, you will have both Save and Merge buttons from the start, and clicking Merge will automatically save your changes before proceeding. If you wish to discard changes to the template, you must click the Cancel button.
  5. Click Merge button to save your changes and proceed to the actual email merge-and-send process:



Step 3 - Preview and Send the Merged Messages

  1. Click Merge, and then select a CSV data source



  2. Map each template placeholder to a column name in the structured data source, and indicate whether this column should be used for record de-duplication.

    mbox => E-mail Address lastName => Last Name firstName => First Name





  3. Merge the data with the template, and preview the mapping and email messages:
    • Table showing mappad data



    • Preview single message



  4. Send messages

Glossary

Related