Sending emails dynamically based on ID

[mkankaria]

Hi everyone,

Sample Case-

ID     Email                     Data     

1      ab@gmail.com       apple

1      ab@gmail.com       banana

2      bc@gmail.com       pear

3      cd@gmail.com       orange

3      cd@gmail.com       melon 

I am trying to send emails out to a list of people containing some data based on an ID. However, some ID's are grouped together based on another list i.e it is possible for ID 1 and 3 to be linked to the same company, so would need to receive 1 email containing data from both. And each id can have multiple lines of data that would still only go out in 1 email combined (ID 1 would send 1 email containing apple and banana). I've seen solutions to send a separate email for each line but how can I email a data set only once per ID?

Any help would be appreciated,

Thanks!

[FilipR · Accepted solution]

@mkankaria You just need to use the Summarize tool. Group by ID and e-mails. You can concatenate your Data column with a ", " as separator for example. You can also use the "\n" separator to put each grouped row in a separate row within a cell.

[mkankaria]

This worked, thank you!