How to clean a mailing list before you spend a dollar on postage

This is the least interesting part and it decides the outcome

Nobody wants to talk about deduplicating a spreadsheet. It is the part of direct mail that has no creative in it and no story to tell afterwards. It is also the part that determines whether the mailing works, because a piece sent to a wrong address costs exactly as much as a piece sent to a right one.

At a dollar and a half all-in, a two thousand name file with three hundred bad records is throwing away four hundred and fifty dollars an issue. Nobody notices, because the waste never shows up as a line item.

Start by deciding what the list is for

Before touching the data, be clear about who belongs on it. A newsletter list is people with a real relationship to you: past and current clients, referral sources, people who asked to hear from you, people you have actually met.

It is not a purchased list, and it is not everyone who ever emailed the office. If a name would not recognize your firm on an envelope, it is a prospecting mailing, which is a different product with different economics. Keeping the two files apart is the first act of hygiene.

Consolidate every source into one file first

Most small businesses have the list in four places: the practice management or case system, an old email tool, a spreadsheet someone kept, and a stack of business cards. Merging those is where duplicates come from and it is also the only chance to catch the names that only exist in one of them.

Get everything into one file with consistent columns before you clean anything. Cleaning four files separately and then merging them creates the duplicates you just finished removing.

Duplicates hide behind small differences

Exact-match dedupe catches almost nothing useful. Real duplicates look like Robert and Bob at the same address, a maiden name and a married name, a person entered once with a suite number and once without, and a married couple entered as two records who will receive two identical envelopes on the same day.

That last one is worth catching for reasons beyond cost. Two copies of the same newsletter arriving at one house reads as carelessness, and it is the kind of thing people mention.

• Match on address plus last name, not on the whole row.
• Normalise names before comparing — case, punctuation, nicknames, middle initials.
• Decide a household rule and write it down: one piece per address, or one per named person. Either is fine. Drifting between them is not.
• When two records disagree, keep the one with the most recent contact date, not the one that sorts first.

Standardise the addresses, then validate them

Address standardisation is the step where a file gets rewritten into the format the USPS actually uses — a consistent street suffix, a proper secondary unit designator, the correct ZIP+4. It is not cosmetic. Presort software will not accept a file it cannot parse, and the postage discounts depend on a clean barcode.

Validation is the next step and a separate one: checking the standardised address against the delivery point database to confirm the address exists and can receive mail. A well-formatted address to a unit that does not exist still fails.

NCOA, and why South Florida makes it urgent

The USPS maintains a National Change of Address file from the change-of-address forms people file when they move. Running your list against it replaces old addresses with new ones for anyone who filed within the coverage window.

This matters everywhere and it matters more here. South Florida is a place where people move constantly — seasonal residents who split the year, renters in a market that reprices annually, retirees moving between communities, families relocating in and out of the state. A client list here decays faster than the same list would in a town where people stay put for twenty years.

Run NCOA before every mailing if you mail quarterly, and at least twice a year if you mail monthly. It is inexpensive relative to what it saves.

Dead records are not the same as bad addresses

Separate from deliverability, there is the question of whether a name should still be on the file at all. A person who has not transacted, replied, referred anyone or been in touch for eight years is not necessarily a bad address. They may just be done.

This is a judgment call and it should be made deliberately rather than by neglect. Some businesses have a genuinely long cycle — an estate plan gets revisited a decade later — and keeping cold names is correct. Others do not, and are paying to mail people who will never come back.

• Anyone who asked to be removed comes off immediately and stays off. Keep a suppression list so a future import cannot resurrect them.
• Deceased records need removing with care, and a mailing that arrives for someone who has died is the single worst thing your newsletter can do.
• Businesses that have closed, and contacts at businesses who have left, are dead records dressed as good addresses.

Then keep it clean, which is the actually hard part

A one-off cleanup feels productive and decays immediately. The file starts degrading the day after you finish, and by the fourth issue you are back where you started unless something maintains it.

The maintenance is boring and short: process the First-Class returns and forwards after every drop, capture new clients into the same file at intake rather than into a new spreadsheet, and run NCOA on a schedule. Fifteen minutes a month, done every month, beats a day of cleanup once a year.

1. Collect returns and address-change notices from the last drop.
2. Apply them to the master file, not to a copy.
3. Add anyone new since the last issue from intake.
4. Run NCOA on the schedule you set.
5. Re-run dedupe on the merged result before it goes to print.

What we do with it

When we take on a newsletter, the list is the first thing we look at and often the first thing that has to change. It is not unusual to find a file that shrinks by a fifth once the duplicates and the dead records come out, and that shrinkage is money back in the client’s pocket every single issue.

It is also why we mail most client lists First Class. The forwards and the returns are free list maintenance, and giving them up to save postage is a trade that goes bad quietly.