How to Clean a Mailing List Before You Mail

A clean mailing list is the difference between a direct mail campaign that pays back and one that burns your budget on undeliverable pieces. Every bad address in your list is money wasted — printing, postage, and handling on a piece that will never reach a human being.

The process of cleaning a list involves four distinct steps, each solving a different problem. At Cornerstone Services, we run all four on every list — whether we build it from our data sources or you supply it from your own database. This guide explains what each step does and why skipping any of them costs you more than the cleaning fee.

Step 1: CASS Certification

CASS (Coding Accuracy Support System) is USPS-approved software that verifies every address in your list against the USPS master address file — a database of every deliverable address in the United States, updated continuously from postal carrier data.

CASS does three things:

Corrects formatting. Addresses in raw data files frequently have inconsistent formatting — “Street” versus “St,” “Avenue” versus “Ave,” inconsistent capitalization, missing directional indicators (N, S, E, W). CASS standardizes every address to USPS format so the automated sorting equipment can read and process it.

Appends ZIP+4 codes. The basic five-digit ZIP code identifies a post office. The four-digit extension narrows to a specific delivery range — a block, a building floor, a PO Box group. ZIP+4 codes are required for Intelligent Mail barcodes and are what qualify your mailing for the lowest presort automation rates. Without them, you pay higher postage.

Flags non-existent addresses. If the street number does not exist on that street in that ZIP code, CASS flags it as undeliverable. These records are removed from the list before printing.

After CASS, you typically suppress 3–7% of raw records — those are addresses that failed verification and would have resulted in undeliverable mail.

Step 2: NCOA Processing

NCOA (National Change of Address) addresses the most common cause of undeliverable mail: the person moved. The USPS NCOA database contains 48 months of change-of-address filings — approximately 160 million records. Running your list against this database either updates addresses for known movers or suppresses records where no forwarding address is available.

NCOA is not optional for presorted mail. The USPS requires NCOA processing within 95 days of your mail date as a condition of the automation postage discount. If you skip it, you lose the presort rates that typically save $0.15–$0.25 per piece — on a 5,000-piece campaign, that’s $750–$1,250 in additional postage.

After NCOA, you typically suppress an additional 2–5% of records (people who moved and could not be forwarded) and update 1–3% with corrected addresses.

Step 3: Deduplication

Deduplication identifies and removes duplicate records from the list. Duplicate records waste print and postage budget by mailing the same person multiple times. They also create a poor impression — a recipient who receives three identical pieces immediately suspects your data quality.

Duplicates arise in several ways:

• A name appears twice with slightly different spellings (“Sean Griffin” and “S. Griffin”)
• The same address appears under two different names (husband and wife listed separately in the source data)
• Records merged from multiple source databases overlap
• Previous campaign suppressions were not applied

Deduplication uses matching logic that catches common variations — name format differences, middle initial presence/absence, address abbreviation differences. The result is one record per deliverable household (or per individual, depending on your suppression preference).

For campaigns targeting households (one piece per address), Cornerstone deduplicates to one record per unique delivery point. For campaigns targeting individuals, we deduplicate to one record per person.

Step 4: Merge/Purge

Merge/purge is an optional but often valuable step that suppresses your existing customers from a purchased list. If you are running a new-customer acquisition campaign, you typically do not want to spend money mailing people who already buy from you.

To run merge/purge, you supply your house customer file (Excel or CSV). We match it against the purchased list using name and address matching logic and remove any records that appear in both files. The result is a purchased list that has been cleaned of existing customers.

Merge/purge is included at no additional charge when you print and mail with Cornerstone. It can also be applied to your own list before mailing if you want to suppress a segment — former customers, people who requested removal, recent buyers who don’t need a reactivation offer.

What You Get After Cleaning

After all four steps, you have a file with:

• Every address standardized to USPS format with ZIP+4 codes
• Addresses updated for known movers (NCOA matches)
• Non-existent and unforwardable addresses removed
• Duplicate records eliminated
• Existing customers suppressed (if merge/purge was requested)
• Intelligent Mail barcode qualification confirmed

This file is mail-ready. If you are printing and mailing with Cornerstone, it goes directly into our inkjet addressing system. If you are printing elsewhere or using the list for other purposes, we deliver it as a formatted Excel or CSV file.

Cleaning Your Own House List

If you maintain a customer database, it needs periodic cleaning too. Customer lists accumulate bad addresses through natural address decay — moves, business closures, deaths. A customer database that has not been NCOA-processed in two years may have 8–12% outdated records.

Cornerstone processes your house files the same way we process purchased lists: CASS, NCOA, deduplication, format standardization. If you mail with us regularly, we recommend refreshing your house file with NCOA every 95 days. For annual mailers, we clean the file fresh before each campaign.

The cost is $75 per 1,000 records for processing-only jobs (where you’re not printing and mailing with us). For all campaigns run through Cornerstone, cleaning is included.

Common List Problems and How Cleaning Fixes Them

Even well-maintained databases accumulate issues over time. Here are the most common problems we see when clients bring us their house files:

Mixed formatting from multiple sources. A customer database built over 10 years from web forms, trade show signups, phone orders, and point-of-sale entries will have wildly inconsistent formatting. “123 Main Street, Apt. 4” in one record and “123 Main St #4” in another — same address, two different records. CASS standardization resolves all formatting variations to a single USPS-standard format, and deduplication catches the resulting duplicates.

Deceased individuals still on active file. Without death file suppression, deceased customers remain in the mailing database indefinitely. Family members receiving mail addressed to a deceased relative have a negative reaction to the sender. At Cornerstone, death file suppression is included in every list cleaning pass — we match against the Social Security Death Master File and remove confirmed deceased records.

Apartment and suite number errors. Multi-unit addresses without correct unit numbers may be delivered to the wrong recipient or returned as undeliverable. CASS processing validates unit numbers against the USPS Delivery Sequence File but cannot always resolve ambiguous unit designations. For high-value mailings where apartment delivery accuracy matters, consider using the USPS SuiteLink service, which matches business addresses to specific suite numbers.

PO Box versus physical address conflicts. Some records have PO Box addresses while others have physical street addresses for the same individual. If your campaign requires physical addresses (for example, EDDM-format mail that cannot be delivered to PO Boxes), the cleaning process should flag or suppress PO Box records. CASS identifies PO Box records during standardization.

Records with no ZIP code or wrong ZIP code. Data entered manually — especially from phone orders or handwritten forms — frequently has missing or incorrect ZIP codes. CASS certification resolves this by looking up the correct ZIP+4 from the street address. Records where neither the street address nor ZIP code match USPS records are flagged and suppressed.

The Cost of Not Cleaning

The math is straightforward. On a 5,000-piece campaign at $0.75 per piece all-in (printing, addressing, postage), the total campaign cost is $3,750. If 10% of the list is undeliverable because it was not cleaned, 500 pieces are wasted — $375 in pure waste. The cleaning fee for 5,000 records at $75 per thousand is $375.

But the waste calculation is actually worse than the direct dollar comparison suggests:

Lost presort qualification. If your list is not NCOA-processed within 95 days, you lose automation presort discounts. On 5,000 pieces, the postage difference between automation Marketing Mail and single-piece rates can exceed $1,000. The $375 cleaning fee prevents $1,000+ in postage surcharges.

Returned mail processing. Undeliverable pieces with the Address Service Requested endorsement cost $0.45–$0.80 each when returned. 500 returned pieces at $0.60 each adds $300 in return fees — on top of the $375 in wasted production cost.

Brand impression damage. Mail addressed to a previous occupant, a deceased person, or a non-existent address reflects poorly on the sender. Recipients who see their neighbor’s name on your mail piece form a negative impression of your data quality and, by extension, your business quality.

Missed opportunities. Every piece mailed to a bad address is a piece that did not reach a live prospect. On a campaign designed to generate a 2% response rate, 500 wasted pieces represent 10 potential responses lost.

When to Clean: A Quick Reference

Situation	Action
Before any mailing	CASS + NCOA (mandatory for presort rates)
House file not processed in 6+ months	Full clean: CASS, NCOA, dedup, death suppression
Purchased list for first use	CASS + NCOA (usually pre-processed by vendor, but verify)
Reusing a list from a previous campaign	Re-run NCOA (required if 95+ days since last processing)
Merging multiple lists or databases	Full clean + dedup across all source files
After a campaign with high return rate (>4%)	Immediate clean with returned-mail data applied
Annual house file maintenance	Full clean regardless of campaign activity

Preparing Your List for Cleaning

To get the best results from list cleaning, provide your file in a structured format:

Required fields: First name, last name, street address, city, state, ZIP code. The more complete the address data, the better the CASS match rate.

Helpful fields: Company name (for business records), apartment or suite number (separate column preferred), phone number, email address. These fields assist with deduplication when address-only matching is insufficient.

File format: Excel (.xlsx), CSV, or tab-delimited text. We accept any standard database export format. Avoid PDF lists or scanned documents — these require manual data entry before processing.

One record per row. Each row should represent one individual or household. Avoid merged cells, header rows repeated throughout the file, or multiple addresses in a single cell.

At Cornerstone, we review every file before processing and contact you if there are formatting issues that need resolution before cleaning can proceed. There is no charge for the file review.

For questions about processing your specific list, call (845) 255-5722 or request an estimate. We accept lists in Excel, CSV, or any standard database export format.