Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

How do I do a mail merge with Gmail?

share|improve this question

3 Answers 3

I found EmailBee provides an easy way of doing mail merges using your Gmail account:

  1. Click

  2. Click "Sign in with Google" and go through the account creation process (basically a couple of clicks)

  3. Once you are in, click "mailbox" on the left hand menu and then the "add mail" icon on the top right of the screen and away you go

NOTE: If you want to send to your Gmail contacts you need to import them:

  1. Click contacts on left hand side menu and then add contact on top right

  2. Select the "import" tab, click "google", click next and then click "start import"

If you use Google Chrome they also have a Chrome Extension which runs inside your Gmail client on Chrome.

share|improve this answer

Here's an excellent video tutorial on using gmail, google sheets and the free Yet Another Mail Merge add-in to do a mail merge:

Create a Mail Merge with Gmail and Google Drive / Docs

You write a draft email in gmail, use this format to refer to column names in your google sheet when writing the email: $%contact email address% where 'contact email address' is the column name, then click the 'mail merge' button, choose the gmail draft you want to send, test it on yourself if you wish, then send it to everyone in your spreadsheet. Very straightforward.

share|improve this answer

Labnol has a video tutorial and walkthrough.

The key is that:

you ... setup Mail Merge in Gmail through your Google Docs account


There is an update to the Labnol article that shows how to add attachments - Labnol tutorial

(thanks to mvark)

share|improve this answer
This is a great solution - however would like to add attachment/s? – CWCarlos Sep 17 '10 at 13:15
@CWCarlos - Don't know the answer to that I'm afraid. – ChrisF Sep 17 '10 at 13:53
@CWCarlos you can simply put your attachment to the Public folder in Dropbox and adding the link to it as a text in the body. Zip them if there are more than one file for easier download! ( – Lipis Oct 17 '10 at 14:24
There is an update to the Labnol article that shows how to add attachments - – mvark Jan 26 '11 at 16:32
@mvark - I've updated the answer with your link - thanks. – ChrisF Jan 26 '11 at 16:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.