How to schedule a bulk email or mail merge in Gmail
Gmail's own Schedule send works on one email at a time. To schedule a personalised email to a whole list, prepare it in Mailroom, choose a date and time, and it is sent then from your Gmail account, one individual email per person. Scheduling is included on the free tier.
Step by step
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 one email with merge tags
Write the subject and body once. Wherever you want a value from the spreadsheet, type the column name in double curly braces, for example {{first_name}}. You can use bold, italic and links.
Preview and send yourself a test
Step through the preview to see exactly what each person will receive, then send a test to your own address. Mailroom warns you if a tag does not match any column.
Pick when it should go
Instead of sending now, choose Schedule and set the date and time. You can close the browser: Mailroom sends it for you and the project shows the result afterwards.
Good to know
- Scheduled sends are picked up within a few minutes of the time you choose, then go out about one a second.
- A scheduled send counts against the day it is actually sent, on both Gmail's limit and Mailroom's.
- 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
Do I have to keep my computer on?
No. The send runs on Mailroom's servers through the Gmail API, so your computer and browser can be off.
What time zone is used?
The time you pick is in your own browser's time zone.
Can I split a big list over several days?
Yes. Upload the list in parts as separate projects and schedule each for a different day. The sending calculator shows how many days a list needs.
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