search database to identify addresess
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.

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-&gt;Communication-&gt;Label Formats in the main menu.