Email trigger to multiple receipants

Hi,

I have this requirement as mentioned below :

Input 1 :

Invoice #	Handler ID
123A	A;B;C
345B	A

Input2 :

Hnadler ID	Handler mail id	Handler Name
A	AAA@xxx.com	Smith
B	BBB@yyy.com	John
C	CCC@zzz.com	Kary

How can i send one email including A,B,C for invoice 123A and other email to A for invoice 345B . Also note there is no email id in input 1 . That needs to picked up from Inputy2 .

Thanks

Email

Accepted answers

All comments

@praneshsapmm One way of doing this

Email_1107.yxmd

Hello @praneshsapmm

You would you be able to dynamically solve this by doing something like the attached workflow.

Hope this helps!

samplemultipleemail.yxmd

1. Split handler ID using rows to columns and split to rows using delimiter ';'

2. join 2 data sets on Handler ID which results in 4 rows in the J anchor

3. Connect J anchor output to your table and select group by based on "Invoice #", this will auto create 2 group tables

4, connect to email tool and select the table as the bod of the email and , to email 'Handler mail id'

If this worked for you , please accept the solution

Quick Links

Tags

This months top contributors

Hollingsworth 335