Query results not showing all email addresses

Do your missing emails have a different type than the ones that are being displayed? It sounds like you might be using the Email Number field under the Specific Phones node, which will only display emails with the "Email" type. If you have other email-related types (such as Email 2, Work Email etc.) then they won't show up in the query unless you go to each of the relevant types under Specific Phones and add them as additional columns. It will probably be easier to use export, otherwise you'll have to have a bunch of different columns in your query just for email addresses, you'll have duplicate lines if people have more than one email address of the same type, and it might be difficult to exclude inactive email addresses.


Export is (usually) the best way to get data out of RE. You can't preview the data within RE like you can with a query, so you won't be able to see it on the screen prior to exporting, but you should be able to send the data to Excel using the CD icon on the menu bar. It's also really easy to tick a box and exclude all inactive emails without having to try and build that into your query criteria.

@Jason Van Over Emails can be on relationships, individual and org, participant records. I suppose memberships if you have that module too.

@Jason Van Over No, you have to deep dive in Relationships > Individuals > Phones… Do this for each type of relationship like Organization, Contacts. Even Banks if you might have it there.

Then another deep dive into Event Participants….