We have a framework where a lead has 4 different emails. One primary that is used to communicate with them and 3 other options.
1. Email (used for sending emails)
2. Personal Email
3. Business Email
4. Business Email 2
We are a looking for a good way to make sure that we can do replacement of the primary email if it bounces with one of the other email in the priority order listed above. However once bounced email email needs to be tracked on some kind of bounce list so we dont put it back on for that lead as a primary email. it should cycle through each email only once and if it email bounced then it should go into a list or be flagged somehow that we can check before doing another replacement.
looking for some suggestions on how to flag the emails and build a list or custom table to track these bounced email so we can cross check that list or flag before doing a replace.