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
(Created page with "Category: Client Query Wizard ==== Overview ==== The report below will output a list of all contacts and contact email addresses for all active clients in Agency Systems. ...")
 
m
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category: Client Query Wizard]]
+
[[Category: Client Query Wizard]][[Category:Reports]]
 +
<table class="infobox" cellspacing="5" style="background-color: #FFFFFF; width:27em; text-align:left; border-spacing: 2px; line-height:1.5em;">
 +
<tr style="background-color: #bdbdbd; text-align: center; font-weight:bold;">
 +
    <td>Related Pages</td>
 +
</tr>
 +
 
 +
<tr>
 +
<td>
 +
<ul>
 +
<li>[[Report: Client Query Wizard|Client Query Wizard Overview]]</li>
 +
<li>[[Report: Client Query Wizard: Remove Multiple Contacts From CSV|Remove Multiple Contacts from CSV]]</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
 
 +
<tr style="background-color: #d3d3d3; text-align: center; ">
 +
    <td>Related Categories</td>
 +
</tr>
 +
 
 +
<tr>
 +
<td>
 +
<ul>
 +
<li>[[:Category:Reports|Reports]]</li>
 +
<li>[[:Category:Client Query Wizard|Client Query Wizard]]</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
</table>
 
==== Overview ====
 
==== 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.
 
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.
  
[[Report: Client Query Wizard|Click here for a detail explanation of the Client Query Wizard]].
+
See [[Report: Client Query Wizard]] for additional details.
  
 
==== 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 19: Line 46:
  
 
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 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.