Sending emails
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AbhijeetChib one option is to setup one more email tool to this group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs thanks. Will do
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs thanks