How to personalise bulk emails in Gmail with merge tags
A merge tag is a placeholder such as {{first_name}} that is replaced with each recipient's own value when the email is sent. In Mailroom every column in your CSV becomes a merge tag automatically, usable in both the subject line and the body, so one email becomes a personal one for each person.
Step by step
Add the details as columns
In your spreadsheet give each detail its own column with a clear heading: first_name, company, renewal_date, table_number. One row per person.
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.
Insert tags as you write
Type the column heading in double curly braces wherever the value should appear, in the subject or the body: Hi {{first_name}}, your table is {{table_number}}.
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.
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
- Tags must match the column heading exactly, including spaces and capital letters. Mailroom flags any tag that matches no column.
- If a cell is empty, that tag is replaced with nothing. Check the preview for greetings that would read Hi , and fill the gap in your spreadsheet.
- The same tag can be used as many times as you like, and in the subject line.
- 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
What can I personalise?
Anything you have a column for: names, companies, dates, amounts, links, booking references. Whatever text is in the cell is placed into the email.
Can each person get a different link?
Yes. Put the full link in a column and use that column's tag in the email, either on its own or inside a markdown link.
Is there a fallback if a name is missing?
There is no automatic fallback text. The preview shows every recipient's version, so you can spot and fix empty values before sending.
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