Send each row of data to each recipient using email tool

Hi team,

I need your expertise on the email tool. My goal is to send each row of data to each recipient via email (it's travelling data specific to each recipient, hence this feature is needed)

Detailed description:

I have read other posts and tested in Alteryx Designer and confirmed that the email tool can send data to each recipient on each row.

The problem comes when I want to send one row of data to each recipient. How do I do that? I want multiple columns of data to appear in the body of the email, but I can't get it to work. Please also suggest if you could find other alternatives!

Attached is my sample workflow for your reference. Thank you for your assistance.

Alteryx_Help_send_each_row_to_each_recipient.yxzp

Accepted answers

T_Willins

Hi @wuaw,

Let me know if this is not what you are looking for. From what I am understanding, you only want a single email per recipient even if they have more than one line, but you still want to filter the data being sent to the recipient to rows with that recipient email address. I added a Sample tool to the workflow, which will only join a single email to to the table while the table has all the results for that recipient.

Email batch macro v2.jpg

Separate Data to each email recipient v2.yxzp

grazitti_sapna

@wuaw , we can do that by concatenating the fields. Please have a look and share your thoughts.

Thanks.

Alteryx_Help_send_each_row_to_each_recipient.yxmd

T_Willins

Hi @wuaw,

Now I understand what you are trying to do. I think to do what you are trying to do instead of a Formula tool to concatenate the results, use a Table tool and group by Recipient email; then connect to the Email tool.

All comments

T_Willins

Hi @wuaw,

If you want to filter the data by recipient, you can use a batch macro to filter each row by recipient email. Then using a Table tool you can create a single field with all the data you want to send in the body of the email.

Email batch macro.jpg

Separate Data to each email recipient.yxzp

wuaw

Hi @T_Willins

Thank you for the quick reply!

If I don't need to filter by recipient, is there an easier way to do it?

For example, if I have 3 rows of data, I will send 3 emails to whichever recipient listed under the column for email address with the row of data

grazitti_sapna

@wuaw , we can do that by concatenating the fields. Please have a look and share your thoughts.

Thanks.

Alteryx_Help_send_each_row_to_each_recipient.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703