Shared Email Templates for Microsoft Outlook

Populate tables and lists with dataset values

You can populate a table or a list with dataset values by binding the table or the list to the necessary dataset.

To open a quick Datasets cheat sheet, click the button below.

Download cheat sheet

Video: How to populate emails with data from datasets

How to populate emails with data from datasets

By watching this video, you'll find out how to get dataset values inserted into your email messages automatically and interactively.

Bind a table to a dataset

  1. Add a table to the template you're creating or editing. Reserve only one row for dataset values. You'll be able to add as many rows as you need when inserting the ready template into an email message.
    A sample table in a template
  2. Right-click a row that is going to be populated with dataset values, and then select Bind to Dataset.
    The Bind to Dataset option

    Note. Make sure that all the cells in the row are empty because the add-in won't overwrite the data that the cells already contain.

  3. Enter the field name that will be in a dialog showing up when you insert your template into an email message. Select a dataset and columns. Then click OK.
    The Select dataset dialog

    Note. The names of the selected columns will populate the row in the order that they are present in the Select columns box. If a different order is needed, clear all the checkboxes under Select columns, and then select columns in the order required for your table.

    Note. When binding a table to a dataset that contains the Regex field and Regex columns, you can select the Auto-insert matched rows checkbox. With this checkbox selected, data from matched dataset rows will populate the inserted table automatically, without a dialog showing up. If matches are not found, no rows will be added to the table.
    The Auto-insert matched rows checkbox

  4. The names of the selected columns will appear in the row. Save your template.
    A sample table bound to a dataset

When you insert such a template into an email message, you'll see a dialog containing a list of key values (values from the key column of the dataset). To specify the rows that you want to add to the table in your email message, select the corresponding key values. Then click OK.

Tip. To select all the key values at once, click the very first checkbox—the one that is next to the search box.

A list of key values from a dataset in a dialog

In the email message, values from the specified rows will populate the table.
A table populated with dataset values

Note. If you want to get key values from some rows selected automatically, set those rows as default ones.

  • Add the Default Row column to your dataset.
    Add the Default Row column.
  • Mark the rows that you want to make default with any symbol or text.
    Mark default rows.
  • Save the changes.

Unbind a table

To unbind a table from the dataset it's bound to, start editing your template, right-click the bound row, and select Unbind from Dataset.
The Unbind from Dataset option

Bind a list to a dataset

  1. Start creating or editing a template. Decide whether you want to get a bulleted list or a numbered one, and then click the corresponding icon on the template editor toolbar.
    A bulleted list in a template
  2. Right-click the line where the first list item is supposed to appear (to the right of the symbol that you already have) and select Bind to Dataset.
    The Bind to Dataset option
  3. Enter the field name. It will be in a dialog showing up when you insert your template into an email message. Select the necessary dataset and column(s). Click OK.
    The Select dataset dialog

    Note. When binding a list to a dataset that contains the Regex field and Regex columns, you can select the Auto-insert matched rows checkbox. With this checkbox selected, data from matched dataset rows will populate the list automatically, without a dialog showing up. If matches are not found, the list won't be inserted.
    The Auto-insert matched rows checkbox

  4. A list item showing the name(s) of the selected column(s) will appear in the template. Click Save.
    A sample list bound to a dataset

When inserting such a template into an email message, you'll see a dialog containing a list of key values (values from the key column of the dataset). To specify the rows that will form a list, select the corresponding key values. Then click OK.

Tip. To select all the key values at once, click the very first checkbox—the one that is next to the search box.

A list of key values from a dataset in a dialog

Note. If you want to get key values from some rows selected automatically, set those rows as default ones.

In the email message, a list containing values from the specified rows will appear.
A list populated with dataset values

Unbind a list

To unbind a list from the dataset it's bound to, start editing your template, right-click the list item, and then select Unbind from Dataset.
The Unbind from Dataset option

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.