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 |
Solved! Go to Solution.
@AbhijeetChib one option is to setup one more email tool to this group
@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
@binuacs thanks. Will do
@binuacs thanks