MailroomSign in

How to mail merge from Excel to Gmail

Save your Excel sheet as a CSV file, upload it to Mailroom, and write one email using your column headings as merge tags. Each row receives its own personalised email from your Gmail address. Word and Outlook's mail merge only sends through Outlook; this route sends through Gmail.

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

Step by step

  1. Tidy the sheet

    Put the headings in row 1 (for example Email, First Name, Company) and one person per row. Remove merged cells and blank rows at the top.

  2. Save as CSV UTF-8

    In Excel choose File, Save As, and pick CSV UTF-8 (Comma delimited). The UTF-8 option keeps accented and non-English characters intact.

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

  4. Upload the CSV

    Create a project and drop the file in. Mailroom finds the email column and lists your other headings as merge tags. Rows with unusable addresses are flagged with their Excel row number.

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

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

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

Can I use Word's mail merge with Gmail?

Not directly. Word's email merge sends through Outlook. To send through Gmail you need a tool that connects to Gmail, which is what this method does.

My names show strange characters after exporting. Why?

The file was saved as plain CSV rather than CSV UTF-8. Save it again choosing the UTF-8 option.

Does it work with Excel on a Mac, or with Numbers?

Yes. Excel for Mac has the same CSV UTF-8 option, and Numbers can export CSV from File, Export To.

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