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.



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