View source for Report: Client Query Wizard: Print Mailing Labels For All Active Clients Excluding Prospects

[[Category: Client Query Wizard]][[Category:Reports]][[Category:Mailing Labels]]
<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>
</ul>
</td>
</tr>

<tr style="background-color: #d3d3d3; text-align: center; ">
    <td>Related Categories</td>
</tr>

<tr>
<td>
<ul>
<li>[[:Category:Client Query Wizard|Client Query Wizard]]</li>
<li>[[:Category:Mailing Labels|Mailing Labels]]</li>
<li>[[:Category:Reports|Reports]]</li>
</ul>
</td>
</tr>
</table>
The report below will output mailing labels for all active clients in Agency Systems.  Prospects are not included, however that step can be skipped if desired.
==== Overview ====
The [[:Category:Mailing Labels|mailing label]] output format provides a single result per [[Client Profile|client]] sorted in the selected order.  ''(The mailing labels display in the '''Avery Standard 5160''' format with 10 rows and 3 columns.)''

For each client, the following values are included: Client Name and Street Address.  (''The name and address will be replaced with the first contact/driver when the '''Birthday''' filter is used'').

See [[Report: Client Query Wizard]] for additional details.

==== Process ====
#Select '''Client -> Client Query'''.
#Select '''General Client Query'''.  Select '''Next'''.
#:[[File:Clntqrywiz-gen.png]]
#Select '''Additional Filters'''.
#:[[File:Clntqrywiz-gen-1.png]]
#Un-check '''Select prospects'''. Select '''Ok'''.
#:[[File:Clntqrywiz-gen-2-addl-noprospects.png]]
#Select '''Next'''.
#Select a '''Sort Method''', then select '''Next'''.
#:[[File:Clntqrywiz-gen-3-sort.png]]
#Select '''Output Format -> Mailing Labels'''. Select '''Next'''.
#:[[File:Clntqrywiz-gen-4-outputmethod-mailinglabel.png]]
#Select the number of labels per client, then select '''Next'''. 
#:[[File:Clntqrywiz-gen-5-mailinglabels.png]]
#Select '''Finish'''.