• On the Criteria tab, select Addresses, Contact information, Contact type [one of] [double-click specific contact types].
     
    • Click OK.
     
    • Select any other desired fields on the Criteria tab.
     
    • On the Output tab, select the following:

      Record, Full/Organization name

      Address, Contact information, Contact type and Contact number
     
    • Select any other desired fields on the Output and Sort tabs.
     
    • Run the query.
     
    • Export the query to Excel.