Email Tool: Use multiple fields in the body and consolidate all records into 1 email.

Hello Peers,

Is there a way I can use multiple fields in the body and then consolidate all this body (which might contain multiple records) into 1 email. This tool is throwing out an email for every row of the output which is overwhelming.

Thanks in advance.

Preparation

Accepted answers

patrick_digan

Can you provide an example/dummy data? I suspect that you can you use the table tool which would combine all your rows and columns into 1 table. That one table would occupy one record and generate only one email. If that's not what you're looking for, the formula tool or report text tool would both be able to combine multiple fields (but you'd still have the multiple emails unless you put it into a table tool or concatenated it into 1 row with the summarize tool).

Hope that helps!

patrick_digan

You can have your table tool feed into a report text tool. You would select Attach text to existing field and select your table field. Then you can type text in the box below that will add text above your table.

All comments

patrick_digan

Hope that helps!

timewaste

@patrick_digan Great, the table option works. Appreciate it!

timewaste

@patrick_digan Is there a way I can include or use both 'Use Field' and some text to describe the output? TIA!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703