Filtering Addresses

Getting Started

When preparing a mailing in LetterStream, it's important to ensure your addresses are complete and properly formatted. The Job Recipient List/Review page includes a useful feature that lets you filter and sort address data by column to help identify missing or incomplete fields before approving your job.

In This Article

How to Filter Columns

Each column on the Job Recipient List/Review page can be filtered:

  1. Navigate to the Job Recipient List/Review page within your mailing.
  2. Click on the header of any column (e.g., Name1, Address1, Address2, City).
  3. The list will sort alphabetically (A–Z).
  4. Click the same header again to sort in reverse alphabetical order (Z–A).

Default Sorting Behavior

When you first view the page:

  • The list appears in the same order as your uploaded file.
  • The system defaults to sorting by the AcctNo  column.
  • If no sorting is applied, the data remains in its original upload order.

Benefits of Filtering

Sorting by individual columns helps you:

  • Quickly sort addresses alphabetically by any column.
  • Identify missing information—like a blank street address or city name.
  • Spot inconsistencies that may not trigger system warnings.
  • Locate specific recipients quickly
  • Identify duplicates among recipient addresses

This manual review step is especially important for high-volume or time-sensitive mailings.

Tips for Identifying Incomplete Addresses

Use the sorting feature to check for potential issues:

  • Sort by Name1 to confirm all recipients have names listed.
  • Sort by Address1 to ensure no street addresses are missing.
  • Sort by City, State, and Zip to verify complete location details.
  • Sort by Address2 to check for optional but potentially useful secondary address information (e.g., apartment or suite numbers).

Even though the system checks for basic completeness, manual review through filtering is recommended to ensure the highest mailing accuracy.