Email the results of a database query

well as Teodor said that you can’t have repeats in mail body, it is simple to solve with a “variable” or by just joining all the query field records with a formatter

Variable - do a manual append

  • define a variable before the query with Set Variable step and give it empty value
  • do the query
  • repeat througth the query and as sub steps:
  • just mutate the variable with Set Variable but just append new values

Use a join formatter

  • this one is very simple, right after the query do Set Variable and give it as value formatter join string with the record fields

As last step to both solutions - just use the variable in your mail body

Hope it is a bit clear :slight_smile:

2 Likes