Answers.Body: <p>Welcome to this stack community. There are multiple ways you could get what you want.
  I would use the Search Builder functionality. You can find it in the main menu Search-&gt; Search Builder.</p>
  <p><a href="https://i.sstatic.net/9HHBr.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/9HHBr.png" alt="search builder" /></a></p>
  <p>You can search the contacts where the address fields (such as city, street adress, or other address fields) are not empty.</p>
  <p>You can then select actions (what to do with the list). You can export it and deal with it externally or you can select Mailing Labels - print to directly create mailing labels. You would probably want to configure Label format before doing so. You can do that by going to the Administer-&gt;Communication-&gt;Label Formats in the main menu.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-03T15:24:30.237Z
Answers.LastActivityDate: 2021-02-03T15:24:30.237Z
Answers.UserDisplayName: Marko
Body: <p>we have about 1400 people in our database. All have email addresses and some have physical addresses. How can I sort/search so I can produce a list of those who have physical addresses? Once we have this list, is there a way to export that list to create mailing labels? Thanks in advance!</p>
  
Tags: <custom-search>
Title: search database to identify addresess
ThreadText: # search database to identify addresess
  
  (Asked by: username_0 on 2021-02-03)
  
  we have about 1400 people in our database. All have email addresses and some have physical addresses. How can I sort/search so I can produce a list of those who have physical addresses? Once we have this list, is there a way to export that list to create mailing labels? Thanks in advance!
  
  **Tags:** custom-search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-02-03. Score: 3
  
  Welcome to this stack community. There are multiple ways you could get what you want.
  I would use the Search Builder functionality. You can find it in the main menu Search-> Search Builder.
  
  [![search builder](https://i.sstatic.net/9HHBr.png)](https://i.sstatic.net/9HHBr.png)
  
  You can search the contacts where the address fields (such as city, street adress, or other address fields) are not empty.
  
  You can then select actions (what to do with the list). You can export it and deal with it externally or you can select Mailing Labels - print to directly create mailing labels. You would probably want to configure Label format before doing so. You can do that by going to the Administer->Communication->Label Formats in the main menu.
  
  
  ---
  
  