CRM Advance Find to get the list of Pending & Failed Emails

The list of Customer and their email address that have been sent email to them, but they still not received any Email yet.

And here is the Advanced Find Query to List all Customer + Email address that in the list of attempted sending Email, but still Failed or Pending.
We have the relationship, so-called Activities Parties that we can use to do query.

You also can use this Advanced Find method to query about Phone Call (Call with whom), Appointment, and another Type, just change the ‘Activity (Email)’ to any Activity Type as required.