About Services Tools Blog Contact us

School and Association Mailing

Mails schools and parent associations about shoe lists from a directory, leaves out anyone who has unsubscribed, and holds the send until the latest unsubscribe file is applied.

  • Email Automation & Analytics
  • Education
  • Scheduled worker
  • Product
  • Cloud
  • 2026

The problem

A large send to schools and parent associations was squeezed in beside other work. Unsubscribe requests came back afterwards as separate jobs. So did any later change to the message.

What it does

Contacts come from the directory, minus anyone who has already unsubscribed. The send is held until the latest unsubscribe list has been applied. Each message is a short template with the school name and a link to the list. If the message changes later, you edit the template and keep the contact list.

Outcomes

  • Unsubscribed contacts are left out before sending.
  • The send waits for the latest unsubscribe list.
  • A template change leaves the contact list as it was.
  • Every send is logged.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Shoe list directory

Contacts
10
Unsubscribed
2
Eligible
8
Send
Held
Held The 12 October unsubscribe file has not been applied. The queue stays shut.
Schools and parent associations
SchoolContactRoleStatus
Oakridge Primary Helen Crowe PTA secretary Eligible
Northfield Junior Priya Shah PTA secretary Unsubscribed
Meadow Lane Infants James Okonkwo Association chair Eligible
Calder Hill School Amina Rahman PTA treasurer Eligible
Harbour View Primary Tom Ellis Association chair Unsubscribed
Redbrook Community Sophie Lang Parent association Eligible
Kingsmere Academy Daniel Frost PTA secretary Eligible
Ashcombe Primary Ruth Pemberton Association secretary Eligible
Millford Juniors Owen Blake PTA chair Eligible
Fernside School Claire Nguyen Parent association Eligible

Autumn shoe-list send

Held Apply the latest unsubscribe file before anyone is queued.
Unsubscribe file
Load unsubscribes-2026-10-12.csv

Two addresses already match the register. No new rows in this file.

Import
Waiting for the file
Queue the eligible eight
Stays disabled until the hold is lifted. Subject: Shoe list for {{school}}
Send
Queue opens after the file is applied

Message template

Template

Saving changes the subject only. The queued list is not rebuilt.

Amend
Shoe list desk
Subject: Shoe list for {{school}}

Dear {{contact}}, the shoe list for {{school}} is ready. Open it here: {{list_link}}

Queue size stays at 8

Unsubscribe register

On the register
2
Already excluded from the queue
Next preview
8
Drops when a sent row unsubscribes
Register
SchoolContactState
Northfield JuniorPriya ShahUnsubscribed
Harbour View PrimaryTom EllisUnsubscribed
Second preview
SchoolContactNext send
Oakridge PrimaryHelen CroweIn preview
Meadow Lane InfantsJames OkonkwoIn preview
Calder Hill SchoolAmina RahmanIn preview
Redbrook CommunitySophie LangIn preview
Kingsmere AcademyDaniel FrostIn preview
Ashcombe PrimaryRuth PembertonIn preview
Millford JuniorsOwen BlakeIn preview
Fernside SchoolClaire NguyenIn preview
From a sent row
Claire Nguyen is still in the next preview

How it works

  1. Load school and parent-association contacts from the directory.
  2. Grey out contacts already on the unsubscribe list.
  3. Hold the send until the latest unsubscribe file is applied.
  4. Queue the rest for sending, with the school name and the list link filled in.
  5. Move a contact onto the unsubscribe list when they unsubscribe from a sent email.
  6. Edit the template without rebuilding the contact list.

Pipeline

flowchart LR
  A[Directory] --> B[Unsubscribe]
  B --> C[Hold]
  C --> D[Template]
  D --> E[Queue]
  E --> F[Log]
  F --> G[Amend]