MailroomSign in

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.

Try it free100 emails a day free. No card, nothing to install.

Step by step

  1. 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.

  2. 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.

  3. 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.

  4. 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}}.

  5. 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.

  6. 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

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