Email sent per Group of Rows

[kkkim]

Hi, Alteryx Community:

I am trying to send one email group. The number of groups is dynamic. So we won't always have fixed set of unique Col A values.

Please see below example:

Input:

Col A	Col B	Col C
Apple	xxx	xxx
Apple	xxx	xxx
Apple	xxx	xxx
Banana	xxx	xxx
Cherry	xxx	xxx
Cherry	xxx	xxx

I would want to send out email based on Col A group. So email will be separated as below:

One email for all Apple

Col A	Col B	Col C
Apple	xxx	xxx
Apple	xxx	xxx
Apple	xxx	xxx

One email for Banana

Col A	Col B	Col C
Banana	xxx	xxx

One email for Cherry

Col A	Col B	Col C
Cherry	xxx	xxx
Cherry	xxx	xxx

Any ideas on how to configure this?

Thank you so much for your help!

[Felipe_Ribeir0 · Accepted solution]

Hi @kkkim 

You can use the sample tool configure like this, each row will send just one email.

If the data that you want to send to each email needs to be embedded on the body of the email, you can do it using the table tool:

If the data need to be sent through attachment, you can use block until done + formula + output tool

•