Searching for All Records with a Known Email Address
Pulling a list of all records in your database with an email address is best done via Contacts. Just follow these steps:
Click on Contacts.
Click on Filters.
Click on Add Filter Option.
Scroll down to or search for Email and then click on it.
Select Is Known.
Click Add Option (your screen will look like the screen shot below).
Click Fetch Results or Save Filter. Doing so will run the search, and when the results load, you will have all records in the database that have at least one email address saved to their profile.