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.
Get the day's new records
The sheriff's arrest list, or the new probate or foreclosure filings.
Find each person's court case
It is usually on a different website from the list.
Find the home address
It is often inside a court PDF.
Check who you already have
Is this person already on your list, or already mailed?
Take out repeats and do-not-mail names
So nobody gets mailed twice, or mailed after they asked you to stop.
Check the address
Is it complete, and does it look like it will get delivered?
Format the file
Set it up the way your mail house wants it.
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.
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.
What software does, and what a person keeps
| Step | What software does | What a person still does |
|---|---|---|
| Get the day's records | Downloads each county's list, in that county's format | Nothing, unless a site is down |
| Find the court case | Searches the court site for each name | Checks the records it flags |
| Read the address | Reads the scan and pulls out the address | Checks any address it is not sure about |
| Repeats and do-not-mail | Removes exact matches | Decides the close calls |
| Format the file | Builds the file in your mail house's format | Nothing |
| Send it | Sends approved records to your mail tool, CRM, or sheet | Approves 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.
| Option | Fits when |
|---|---|
| Buy a data feed | A vendor covers your counties and gives the fields you mail on |
| A ready-made scraper | Your counties are common, and someone on your team can fix it when a site changes |
| A VA or a person on staff | You cover a few counties and the daily count is low |
| A custom build | You 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.