Skip to the main content

How a public-record direct-mail list gets built, and which steps to automate

Each morning someone pulls the new records from the county, like arrests or probate filings. They look up each person on the court site and find the home address, often in a scanned PDF. Then they take out people already mailed and do-not-mail names, check the address, and format the file for the mail house. Most of that can be automated.

By Rayhan AhmedUpdated 7 min read

The daily job, start to finish

A public-record mail list is built fresh every day. The steps are the same for arrests, probate filings, foreclosures, or evictions. Only the sites change.

  1. Get the day's new records

    The sheriff's arrest list, or the new probate or foreclosure filings.

  2. Find each person's court case

    It is usually on a different website from the list.

  3. Find the home address

    It is often inside a court PDF.

  4. Check who you already have

    Is this person already on your list, or already mailed?

  5. Take out repeats and do-not-mail names

    So nobody gets mailed twice, or mailed after they asked you to stop.

  6. Check the address

    Is it complete, and does it look like it will get delivered?

  7. Format the file

    Set it up the way your mail house wants it.

  8. A person approves it

    Then the list goes out.

On the job I run every day, steps 1, 2, 3, and 8 are automated, for arrest records. The rest of this guide goes through each step. It says which parts come from that job and which are general practice.

Why a person ends up on several county websites

The list and the address are almost never on the same site.

On the county job, the arrest list comes from the sheriff's website. The address sits in a court PDF on the county court website. So a person reads a name on one site and searches it on another. They open the PDF and copy the address. Then the next name.

And every county is different. One sheriff posts a PDF, another a table on the page, another a CSV file. Each court site searches in its own way. Add a county, and you add new sites to learn.

I run this job for a court-data lead company based in Florida. It covers Seminole and Broward counties in Florida and Tarrant County in Texas, with a fourth on the way. Together that is about 250 to 300 records a day. By hand, it would take 4 to 5 hours of someone's day.

How to automate county court lookups when the site has no API

Where the address is in the court record

On the county job, the home address is on the first page of the court PDF. It is usually on one line: street, city, state, and ZIP.

The catch is that the PDF is often a scan. It is a picture of paper, so you cannot search it or copy from it. Software reads it with text recognition (OCR) first. Then it pulls out the address line and splits it into fields.

Why not use the sheriff's list alone? On this job, the list gives a name and a booking ID, and sometimes a date of birth. It does not give a mailing address. The address only comes from the court record.

How to pull names and addresses out of scanned court PDFs

Matching new records to people you already have

This part is general practice. It is how matching is usually done, not a picture of the job above.

A new record might be someone you mailed last month. Or someone already on today's list from another county. To tell, you compare more than the name:

  • Name and date of birth. Much better than a name alone.
  • Booking ID or case number. Exact, but only inside one county.
  • Address. Useful once it is in a standard format.

A name alone is not enough. Common names repeat. The same person can show up with or without a middle name, or with a typo.

The rule I follow on every job: when a match is not clear, flag it for a person. Do not join two records by guess, and do not drop one by guess either.

Repeats and do-not-mail names

This part is also general practice.

Repeats are the same person twice. They were arrested twice in one week, or they show up in two counties. You keep one record and drop the rest.

Do-not-mail names are people you must not mail. Most companies keep their own list of people who asked them to stop. Some clients send their own list too. Some companies also check an industry opt-out list, like DMAchoice.

DMAchoice, the mail opt-out list

Two habits help:

  • Remove them before you format the file, so a name never slips into the mail file.
  • Keep a note of what was removed and why. When someone asks why a person was left out, or why they were mailed, you can answer.

Software is good at the exact part: the same ID, the same name and birth date, a name on the do-not-mail list. The close calls go to a person.

When the address can't be found or checked

On the county job, the rule is simple: no address, no guess. If the court record or the address cannot be found, the record goes to its own list. It never gets a made-up address.

Checking that an address is good is general practice. Mail-ready addresses follow the USPS address format. Many mail houses also check addresses before they print. Ask yours what it already checks, so you do not pay for the same check twice.

USPS Publication 28: how a mail address should be written

What software does, and what a person keeps

Each step of a public-record mail list, split between software and a person
StepWhat software doesWhat a person still does
Get the day's recordsDownloads each county's list, in that county's formatNothing, unless a site is down
Find the court caseSearches the court site for each nameChecks the records it flags
Read the addressReads the scan and pulls out the addressChecks any address it is not sure about
Repeats and do-not-mailRemoves exact matchesDecides the close calls
Format the fileBuilds the file in your mail house's formatNothing
Send itSends approved records to your mail tool, CRM, or sheetApproves the day's list

On the county job, a person sees every record before it goes out. A wrong address costs money, so nothing ships without a check. It is a quick look on one screen, not a trip through three websites.

Before you mail: check the rules

Rules on using public records for mail differ by state and by record type. Arrest records most of all: some states limit who can mail people about an arrest, and how soon after.

Ask your own lawyer about the records you use and the states you mail into. This is not legal advice. It is the question I raise before I build.

Who can automate this

There are four ways to get this done. Each one fits a different firm.

Four ways to get a public-record mail list built, and when each fits
OptionFits when
Buy a data feedA vendor covers your counties and gives the fields you mail on
A ready-made scraperYour counties are common, and someone on your team can fix it when a site changes
A VA or a person on staffYou cover a few counties and the daily count is low
A custom buildYou need counties, fields, or a format no one sells, like the address inside a court PDF

Buy, scrape, hire, or build: the four options compared

Quit Clicking does the last one. Here is how it goes:

  • One county first. It gets checked on your real records before the next one starts.
  • Each county gets its own scraper. A change on one court site does not stop the others.
  • A first working version within 7 days. Then a live run on your own records before handover.
  • Built in your own accounts, so the job and your data stay with you.
  • A review screen where your team checks and approves the day's list.
  • 30 days of free fixes after handover.

Read next

For lead list companiesThe county records case studySee what the task costs you now

Questions about public-record mail lists

Have one that is not here? Write to me.

rayhan@quitclicking.com
Does this work for probate or foreclosure lists, not only arrests?

Yes. The steps are the same: get the new filings, find the record, read the document, clean the list. The live job I run is for arrest records, so I check each new record type on real data first.

Can it use my own do-not-mail list?

Yes. Your list is checked before the file is built, and close matches go to a person.

What if my county posts its list as a PDF?

That works. Counties post PDFs, tables on the page, and CSV files, so each county gets its own step to read its own format.

Does a person still check the list before it mails?

Yes, and I would not skip it. The software does the finding and the reading. Your team makes the call.

Can the list go straight to my mail house?

Yes. Send me a sample file from your mail house, and the list comes out in that exact format.

Name one job your team still does by hand

You get a reply within 2 business days: can it be automated, how, and about what it would cost. It is free, and you owe nothing.

The Check is a written answer. No build, no full audit.