~%DatasetValue

• Description
• Syntax
• Examples of use
• Deprecated macros

Description

When you paste a template into the current email message or current calendar event, this macro opens the specified dataset, finds a row with the specified key value in the key column, and then inserts the text of the specified column from the found row into the current macro position.

Syntax

~%DatasetValue{
     "dataset":"textvalue",
     "keyvalue":"textvalue",
     "column":"textvalue"
}

Works for

• Email templates.
• Calendar event templates.
• Mail Merge templates.

Examples of use

~%DatasetValue{"dataset":"Store list","keyvalue":"Shop 1","column":"address"}

Deprecated macros