Sending emails

[AbhijeetChib]

I have a requirement where I need to send multiple emails. So I group them on the basis of a field "Duplicate group" which is in pairs. So when the emails are triggered they have a table with one pair of duplicate ID. From the below table, 10 emails should trigger. 

However the challenge is - for a pair of duplicate group if the region is different then the respective emails will also be different. In the below table Duplicate pair ID - 283048 illustrated this. 

In this case I need to send emails to both. How it works for me is one record is sent to each but then I need to send both records to both of the recipients. Please be kind enough to share some ideas. 

1	283048	Spain	Tim	abc@abc.com	y
2	283048	Slovenia	Tim	ghi@abc.com	y

Sample table. 

Sl.No	Duplicate Pair ID	Region	User	Email ID	EmailFlag
1	284519	United Kingdom	John	john@abc.com	Y
2	284519	United Kingdom	John	john@abc.com	Y
1	285154	USA	Tim	tim@abc.com	y
2	285154	USA	Tim	tim@abc.com	y
1	285215	Mexico	Tim	tim@abc.com	Y
2	285215	Mexico	Tim	tim@abc.com	Y
1	285254	Japan	Sam	sam@abc.com	Y
2	285254	Japan	Sam	sam@abc.com	Y
1	283041	Bangladesh	Ken	ken@abc.com	y
2	283041	Bangladesh	Ken	ken@abc.com	y
1	283045	Slovenia	Ken	ken@abc.com	y
2	283045	Slovenia	Ken	ken@abc.com	y
1	283047	Spain	Ken	ken@abc.com	Y
2	283047	Spain	Tim	tim@abc.com	y
1	283048	Spain	Tim	abc@abc.com	y
2	283048	Slovenia	Tim	ghi@abc.com	y
1	283049	Spain	Tim	tim@abc.com	y
2	283049	Spain	Tim	tim@abc.com	Y
1	283051	Spain	Ken	ken@abc.com	y
2	283051	Spain	Ken	ken@abc.com	y

[binuacs]

@AbhijeetChib one option is to setup one more email tool  to this group

[AbhijeetChib]

thanks @binuacs 

I am likely to have more than one pair that has such data. What happens then ?

[binuacs · Accepted solution]

@AbhijeetChib All such pairs will be going to the additional email tool and the others will be going to the other email tool I think. Can you try and let e know

[AbhijeetChib]

@binuacs thanks. Will do

[AbhijeetChib]

@binuacs thanks