Fill template fields with dataset values
In Shared Email Templates for Microsoft Outlook
You can add fillable fields to your templates and fill them with values from datasets by using the Insert and WhatToEnter macros. With the Insert macro, you get a value from a dataset inserted into an email message automatically. With the WhatToEnter macro, you can select what value to use while inserting a template into an email message.
To open a quick Datasets cheat sheet, click the button below.
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.
Run time: 07:08
Fill template fields automatically
-
In a template you're creating or editing, place the cursor where you'd like to add an auto-fillable field for a dataset value, and then select Insert macro.
-
Select Insert Dataset Value.
-
Select the necessary dataset, column, and key value (a value from the key column identifying a row from where to retrieve a dataset value). Then click OK.
-
An auto-fillable field will appear in your template. Select Save.
When you insert such a template into an email message, the auto-fillable field will be replaced with a value from the specified column and row.
Fill template fields interactively
If you want to fill several fields in your template with data retrieved from the same row of a dataset by selecting a key value (a value from the key column identifying a row from where to retrieve a dataset value) only once, follow these steps.
-
In a template you're creating or editing, add a fillable field using the Dataset option of the WhatToEnter macro. Learn more.
-
Copy the added field as many times as you need changing the column from where the necessary value must be retrieved.
-
When you're done, save your template.
When inserting such a template into an email message, select a key value to specify the row from where to retrieve data.
In your email message, the template fields will be filled with the necessary values in one go.
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.
