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.
Sample table.
