This solution provide steps on how to run a report that shows records that have mailing addresses.
1. Go to Contacts > Individuals > Click Advanced Search 2. Expand Contacts > Profile > Address Types > Primary Address 3. Click 'Address Line 1' > Click Add 4. On the pop-up screen, select 'Is Empty' > Click Ok 5. Repeat step 3 and 4 for Address Line 2, City, State, and ZIP/Postal Code 6. Click Run Query or Save to Query Library Note: Remember you are query against the 'Primary Address'. In Sphere, your mailing address is the default primary address. In other records, your primary address is the only address you have in your record except billing address.