I'd like to access a reply

Hi @Julio A Vargas (DEECA), 

Thank you for posting your question in the Microsoft Q&A forum.  

It's Jeanie. I can't access the post anymore too (there may be an error in the process of merging the two platforms, so the thread is no longer displayed), so I don't remember your exact question, but I did save my answer. You can review it below. 

Based on my remember, you want to avoid sending emails to addresses that have previously bounced in past mailings. This helps reduce delivery failures, avoid spam flags. 

If I have understood correctly, please allow me to suggest as below that I hope will assist you:  

Prepare your new mailing list: Before your next email, prepare the new list of email addresses you want to send to.  

Then, keep a list of bounced emails: After each mailing, make a list of email addresses that bounced (did not receive the email because of errors). Put this list in a separate sheet or table called “BouncedList”. Keep updating this list after each mailing to avoid sending to those emails again.   

Check your new list against the bounced list: Use Excel to check if an email in your new list is in the bounced list. Use this formula in a new column next to your new emails: =IF(COUNTIF(The range of BouncedList cells you want to evaluate, The condition that determines which cells to count)>0, "Bounced", "OK")  

This formula checks if the email in A2 of your new list appears in the bounced list.  

If yes, it shows “Bounced” meaning do not send.  

If not, it shows “OK” meaning it is safe to send.  

Copy this formula down for all your emails.  

Filter and send only emails marked “OK”: After using the formula, filter your list to show only emails marked “OK”. Send emails only to these addresses to avoid bounced emails.  

After every mailing, update your bounced list with new bounced emails for the next time.  

(Optional) Highlight bounced emails in your list  

To quickly see which emails bounced, you can use Conditional Formatting in Excel:  

Select the email column in your new list.  

Go to Home > Conditional Formatting > New Rule > Use a formula to decide which cells to format.

Enter this formula: =COUNTIF(The range of BouncedList cells you want to evaluate, cells you want to format)>0  

Choose a format like yellow fill or strikethrough.  

If you remember what your question was, please feel free to send it over, and I'd be happy to help. Let me know if you have any other questions. 

Looking forward to your response! 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.