Home → Campaign Manager → Frequently Used Contacts Searches → Records by City

5.4. Records by City

Searching for All Records in Your Database by City

Pulling a list of all records in your database with an address in a specific city is best done via Contacts. Just follow these steps:

1. Click on Contacts.
2. Click on Filters.
3. Click on Add Filter Option.
4. Scroll down to or search for City and then click on it.
5. Select Contains and then type in the name of the city.
6. Click Add Option (your screen will look like the screen shot below).
7. 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 an address in the city you entered in step 5.

Additional Notes

• In addition to Contains, you can use the other option is any of to target records by city. However, the is any of option typically requires use of another filter, such as one specifying state, in order for the Contacts tool to load city choices into the drop-down menu. Therefore, Contains will typically be the easiest way to pull records by city.
• Note that steps above do not specify a state, just the name of a city, so if you have two records with addresses in different states but in cities with the same name, they will both pull to your search results. You can always add more filters to your search to make it more specific.