By industry

Email List Cleaning for Churches and Ministries

A black-and-white cutout of a church bell on a flat lavender background

The church directory was started on index cards. It moved to a spreadsheet in 2004, to the church management software in 2013, and to the email platform the year the youth pastor set it up. Nothing was ever removed. Families who moved to Phoenix in 2011 still receive the weekly bulletin. So does a man who passed away four years ago, and his widow sees the email arrive every Thursday.

A congregation list is small, old and tender. It cannot be cleaned the way a retailer cleans a promo list, and it does not need to be. It needs a quiet, inexpensive routine that removes the addresses that no longer work, handles the sensitive ones with care, and leaves the people who still want to hear from you receiving mail in the inbox rather than the spam folder.

This guide is written for the volunteer or part-time administrator who inherited the list.

Key takeaways

  • Congregation lists accumulate for decades and are rarely pruned. A 1,800-address list is often a 1,200-person congregation plus 600 addresses that no longer work or no longer belong to anyone nearby.
  • A weekly bulletin to a list that bounces at 6% will drift into spam for the members who do read it, and most of them are on Gmail.
  • Deceased members, divorced couples and families who left deserve a careful hand, not a bulk delete. Handle them in the church database first, then clean the email list.
  • Export from the church software, export the bounces, and remove the suppressed addresses while keeping family, ministry and giving columns intact.

Where a congregation list comes from

Churches gather addresses the way they gather everything else: from whoever shows up and writes it down.

  • The member directory. Collected at membership class, updated when someone remembers. The core of the list and the oldest part of it.
  • Visitor and connection cards. Filled out in the pew, handwritten, often by someone who came once for Easter. Legible most of the time; current for about a year.
  • Event and program registrations. Vacation Bible school, the fall retreat, the Christmas concert. Parents sign up with whatever address is on their phone. A share are grandparents and neighbors who are not part of the congregation at all.
  • Online giving. Tithe.ly, Pushpay, Planning Center Giving. The most accurate source, because the giver wants the year-end statement.
  • Volunteer sign-up sheets and small-group rosters. Paper, passed down a row. Transcribed later by a volunteer.

All of it ends up in Planning Center, Breeze, Realm or a spreadsheet, and from there into Mailchimp or Constant Contact. The sync goes one way. When the email platform records a bounce, the church database never hears, and the next sync restores the dead address. The suppression list guide explains why that loop has to be closed.

How a church list ages

Any list loses 20-25% of its addresses in a year to job changes, abandoned accounts and provider switches. A congregation list has three additional patterns.

Families move away and do not unsubscribe. Leaving a church is awkward. Clicking unsubscribe feels like a statement, so people do not. The address stays, the opens stop, and after a year or two the address itself goes dark when they change internet providers.

Young people grow up. The address a 16-year-old gave the youth group is a school or family address that disappears at graduation or when they move out. Ten years of youth programs is several hundred dead addresses.

Members pass away. This is the hardest one. A long-time member's address may stay active for years if a spouse keeps the account, and a weekly bulletin arriving there is either a comfort or a wound, depending on the family. It is not a cleaning question; it is a pastoral one. Handle it in the church database with a conversation, before any bulk process touches the list.

The obituary for an email address is written about the ordinary kind of death an address suffers. A church list contains both kinds.

Start with the visitor cards. If the paper cards from the last few years were never typed in, photograph them. A Pro account includes an Image to CSV tool that reads handwritten sign-in sheets and cards into a spreadsheet, and a typo fixer that catches gmial.com before it bounces. Visitors who came twice and were never contacted are the easiest people to reach.

Why it matters for a list this small

A congregation of 1,200 is not a bulk sender in anyone's imagination, and the platform bill is modest: an 1,800-address list on a per-contact plan runs roughly $30-45 a month, of which perhaps $10-15 is spent on addresses that cannot receive mail. The money is not the reason to clean.

The reason is where the bulletin lands. Most of a congregation is on Gmail, and Gmail judges every sender by bounce rate, complaint rate and engagement. A weekly send that bounces at 6% and is opened by a third of the remaining list looks, to Gmail, like a sender who does not maintain a list. The bulletin drifts into spam, and the member who "never got the email about the funeral" was telling the truth. Gmail does not care about your feelings sets out how the scoring works without any regard for the sender's intentions.

A list that bounces under 2% and belongs to people who open it keeps the bulletin in the inbox. That is the goal.

  1. Tend the database by hand

    Mark deceased members, families who have left and households who asked to stop receiving mail in the church software before touching the email list.

  2. Export the directory with its columns

    Every contact as a CSV with family, ministry, small-group and giving fields intact.

  3. Export bounces and unsubscribes

    From the email platform's cleaned, bounced or removed view, plus the unsubscribe list.

  4. Remove the suppressed addresses

    Upload the directory as the original and the suppression files as suppression lists. Download the cleaned CSV with every column in place.

  5. Update the database and repeat quarterly

    Flag removed addresses so the sync does not restore them, and repeat after Easter, summer, fall kickoff and Christmas.

A quarterly routine for an 1,800-address list

This takes a volunteer about 20 minutes a quarter: a quiet week after Easter, the summer program, the fall kickoff and Christmas.

  1. Tend the database first. In the church software, mark members who have passed away, families who have formally left, and households that have asked to stop receiving mail. This is the step that needs a human, and it should never be done by a bulk tool.
  2. Export the directory. Pull every contact as a CSV with family, ministry, small-group and giving columns. Keep the columns; they are how you segment the youth families from the choir.
  3. Export the bounces and unsubscribes. From Mailchimp or Constant Contact, export the cleaned, bounced or removed contacts and the unsubscribes.
  4. Remove the suppressed addresses. Upload the directory export and the suppression files to Email List Refresh. It removes every matching address and returns the CSV with every column intact. An 1,800-row file is done in a couple of minutes. The free account is enough to look around; a single month of Pro covers the cleanup if your list is too large for the spreadsheet method.
  5. Update the database. Mark the removed addresses as bad in the church software so the next sync does not restore them.

If the budget is zero, the spreadsheet method does the same removal with formulas, more slowly.

The people who have gone quiet

After the bounces are gone, the list still holds families who left years ago and never said so. Their addresses work. They do not open. Every one of them lowers the engagement Gmail sees and raises the chance that a disengaged recipient marks the bulletin as spam.

Once a year, build a segment of addresses with no open or click in 12 months and no giving or attendance record in the church database. Send one email, written by the pastor, not the platform: we have missed you, here is what is happening, would you like to keep hearing from us. Then move the silent ones to a suppression file. Nobody is leaving the church; they are leaving a weekly email they stopped reading. The re-engagement guide has a longer sequence that can be shortened to a single note for this setting.

For members who have moved but want to stay connected, a monthly "news from home" segment is a kinder fit than the weekly bulletin.

What to send once the list is clean

A clean congregation list is a trusted channel. Protect it by sending less and sending it well.

SendCadenceSegment
Weekly bulletinThursdayActive members and regular attenders
Ministry-specific notesAs neededYouth families, choir, small groups, by column
Giving statements and receiptsTransactionalGivers only, from the giving platform
News from homeMonthlyMembers who moved away and asked to stay in touch

Keep giving statements on the giving platform, separate from the bulletin list, so an unsubscribe from the bulletin never stops a tax receipt. And keep the unsubscribe link visible; an unsubscribe is a polite goodbye, and a spam complaint is not.

Free estimate

See what this costs your list

Pick your list size. We will show you the math, then send you a one-page cleanup plan for your platform.

Your estimatePick a list size and platform to see the numbers.
—addresses likely dead this year
—paid per year to store them
—contacts that can still be reached

No spam, no list rental. One email with your plan, then nothing unless you ask.

FAQ

Questions about email list cleaning for churches and ministries

How do I clean up a church email list?

Handle the sensitive records by hand first: deceased members, families who have left, people who asked to stop. Then export the full directory with its columns, export the bounced and unsubscribed addresses from your email platform, and remove the matches so the cleaned list comes back with family and ministry fields intact. Update the church database so the next sync does not restore the bad addresses. Repeat quarterly.

Should a church remove inactive members from its email list?

Remove them from the weekly bulletin, not from the church. After a year with no opens, no giving and no attendance, send one personal note from the pastor asking whether they want to keep hearing from you. Move the silent ones to a suppression file and, if they ask, to a monthly news segment instead. Membership is a pastoral decision; email frequency is not.

Why is our church bulletin going to spam?

Usually because the list has not been cleaned in years. A bounce rate above 2% and low engagement from members who moved away tell Gmail the sender does not maintain the list, and Gmail routes the mail accordingly. Remove bounced addresses, suppress the long-silent, and make sure the sending domain has SPF and DKIM records set up. Inbox placement typically recovers within a few weeks.

How should we handle the email address of a member who has died?

Personally, and before any bulk cleaning. Ask the family whether they would like the address removed or kept, since a surviving spouse sometimes uses it. Record the decision in the church database and apply it to the email list by hand. A bulk tool should never be the thing that makes this choice.

Is there a free way to clean a church email list?

Yes, for a small list. Export the directory and the bounce list, then use spreadsheet formulas to remove the matches; our Excel and Google Sheets guide has the steps. For a list over a couple of thousand addresses or a volunteer short on time, a single month of a $19.99 plan does the same job in minutes and keeps every column.

Clean your list before the next send.

Upload your contacts and every suppression file you have. Download a clean CSV with every column intact. Seven minutes, start to finish.

Envelopes drop into a funnel: good addresses stack up, bad ones are thrown out