~%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

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.