Get all Pending or Failed Emails

hello,

if anyone want to see all pending or failed emails for my contacts in the system, it's very easy.

We have to create Advanced Find Query to List all (Contact , Email Address) that in the list of attempted sending Email, but still Failed or Pending.

We have a relationship  called Activities Parties that we can use to do query.

just go contact entity >>  advanced find  :

1. select the Activities Parties and select participation type and set it to "To Recipient".

2. then select Activity entity(emails) and select status reason and set it to : "Pending" or "Failed"
as below:

 

after that you will have a list of all your contact with failed or pending emails sent to them.