Ukraine flag War in Ukraine. Here's what Ablebits is doing to make sure our team and projects are safe.

~%DatasetValue

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

  • DatasetValue