Automatic Email sending to multiple users

[Payvas]

I have data which looks like this  and it contain multiple email ids. I want to send individual email to each Submitter and which should contain the detail of that particualr advisor only

Acct number	Submitter Email ID	Entry Date	Value Date	Creator name	Transfer Type	Amount
99923949	parul.ghs@gmail.com	07-11-2023	08-11-2023	Parul	3000	455
92939482	paul.ghs@gmail.com	08-11-2023	08-11-2023	Paul	455	3000
92939481	Ashish.ghs@gmail.com	07-11-2023	10-11-2023	Raj	8772	455

Output should look like below

Hi parul,

This is to inform that this is related to your department

Acct number	Submitter Email ID	Entry Date	Value Date	Creator name	Transfer Type	Amount
99923949	parul.ghs@gmail.com	07-11-2023	08-11-2023	Parul	3000	455

Thanks,

Raj Kundra

[alexnajm · Accepted solution]

Hi @Payvas,

Alteryx will send one email per row of data - so because Paul shows up in 2 rows, he'll get 2 emails because each email is unique, there will be three emails sent.

Here is a quick example I created to help out!

Based on how you've described it, you could use a Unique tool to take the first record based on the [Submitter Email ID] column. Or you could use a Sample tool to take the First N records with N=1, grouping by [Submitter Email ID]. This comment seems no longer relevant based on the data problem.

[Payvas]

Great it worked