Email every parent or student individually from Gmail
Put the details in a spreadsheet, one row per student or parent, export it as CSV, and Mailroom sends each of them a separate email from your Gmail or school Google Workspace account with their own details filled in. Nobody sees anyone else's address or information.
Step by step
Prepare the spreadsheet
One row per recipient: email, name, and the details that differ, such as class, appointment time or feedback. Export as CSV.
Sign in with Google
Go to themailroom.cc and choose Continue with Google. This signs you in and connects the Gmail account you will send from. Mailroom asks only for permission to send; it cannot read your inbox.
Upload your CSV
Create a project and drop in a CSV file with a header row. One column must hold the email addresses; Mailroom finds it for you. Every other column becomes a merge tag. Addresses that would bounce (two in one cell, missing domain) are flagged with their row number before anything is sent.
Write the message once
For example: Dear {{parent_name}}, {{student_name}}'s appointment is at {{time}} in {{room}}. Each tag is filled in from that row.
Check every version in the preview
Step through the preview before sending. With personal details it is worth checking each row lines up with the right person, and sending yourself a test.
Send, or schedule it
Press send. Each recipient gets their own individual email from your Gmail address, about one a second. Or pick a date and time and Mailroom sends it then.
Good to know
- Because each email is separate, there is no risk of exposing the class list through a mistaken Cc.
- Works with a school Google Workspace account, subject to your administrator allowing third-party apps.
- Check your school's data protection policy before uploading student information to any online tool.
- Gmail itself allows 500 recipients a day from a personal @gmail.com account and 2,000 a day from Google Workspace. No tool can raise that.
- Mailroom's free tier sends 100 emails a day and 300 a month. A 7-day pass (£7.99 / $9.99, one payment) or Pro (£15.99 / $19.99 a month) lifts that to Gmail's own limit.
Common questions
Is a class set within the free limit?
Yes. 100 emails a day covers several classes, and 300 a month covers occasional whole-year sends.
Can I send individual grades or feedback?
Yes, technically: each row's values go only to that row's address. Preview carefully and follow your school's policy on sending personal data by email.
Will replies come to me?
Yes. Emails are sent from your own account, so replies arrive in your inbox as normal conversations.
Related
Send your first one in five minutes
Sign in with Google, upload a CSV, write one email. 100 a day free.
Start with Mailroom