It is common to require a list of companies and contact details for things such as email marketing etc. You can use the Advanced Export function to filter and export company information as required. The Advanced Export option is located in the Tools menu of the companies list.
Once opened the Advanced Export dialog provides the following options to filter you company list.
Filters can be joined using AND, OR and NOT combinations as required. The query box can be manually populated or you can use the buttons and drop-down lists to build your query. The query is constantly evaluated with any errors noted or the resulting count shown.
Finally use the Export button to export an Excel compatible file.