Difference between revisions of "Report: Client Query Wizard: Export All Active Client Email Addresses Excluding Prospects"

From Agency Systems Wiki
Jump to navigation Jump to search
m
 
(2 intermediate revisions by 2 users not shown)
Line 9: Line 9:
 
<ul>
 
<ul>
 
<li>[[Report: Client Query Wizard|Client Query Wizard Overview]]</li>
 
<li>[[Report: Client Query Wizard|Client Query Wizard Overview]]</li>
<li>[[Report: Client Query Wizard: Remove Multiple Contacts From CSV|Remote Multiple Contacts from CSV]]</li>
+
<li>[[Report: Client Query Wizard: Remove Multiple Contacts From CSV|Remove Multiple Contacts from CSV]]</li>
 
</ul>
 
</ul>
 
</td>
 
</td>
Line 33: Line 33:
  
 
==== Process ====
 
==== Process ====
#Select '''Marketing -> Query Wizards'''.
+
#Select '''Client -> Client Query'''.
 
#Select '''General Client Query'''.  Select '''Next'''.
 
#Select '''General Client Query'''.  Select '''Next'''.
 
#:[[File:Clntqrywiz-gen.png]]
 
#:[[File:Clntqrywiz-gen.png]]
Line 47: Line 47:
 
Once the file is saved, minimize Agency Systems and open the exported CSV file.
 
Once the file is saved, minimize Agency Systems and open the exported CSV file.
  
To remove multiple contacts fro the CSV file, See: [[Report: Client Query Wizard: Remove Multiple Contacts From CSV]].
+
To remove multiple contacts from the CSV file, See: [[Report: Client Query Wizard: Remove Multiple Contacts From CSV]].

Latest revision as of 13:58, 21 August 2019

Related Pages
Related Categories

Overview

The report below will output a list of all contacts and contact email addresses for all active clients in Agency Systems. Prospects are not included, however that step can be skipped if desired.

See Report: Client Query Wizard for additional details.

Process

  1. Select Client -> Client Query.
  2. Select General Client Query. Select Next.
    Clntqrywiz-gen.png
  3. Select Additional Filters.
    Clntqrywiz-gen-1.png
  4. Un-check Select prospects. Select Ok.
    Clntqrywiz-gen-2-addl-noprospects.png
  5. Select Next, then Next on the sort method screen.
  6. Select Output Format -> Comma Separated File (CSV). Select Next.
    Clntqrywiz-gen-4-outputmethod-csv.png
  7. Select the desired save location, and enter a file name. Select Save.

Once the file is saved, minimize Agency Systems and open the exported CSV file.

To remove multiple contacts from the CSV file, See: Report: Client Query Wizard: Remove Multiple Contacts From CSV.