How do I do a mail merge with Gmail?


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)

| 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! (www.dropbox.com) – Lipis Oct 17 '10 at 14:24
  • There is an update to the Labnol article that shows how to add attachments - labnol.org/internet/mail-merge-with-attachments/18561 – mvark Jan 26 '11 at 16:32
  • @mvark - I've updated the answer with your link - thanks. – ChrisF Jan 26 '11 at 16:36

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.

| improve this answer | |

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

  1. Click https://www.emailbee.com/Account/Register

  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.

| improve this answer | |

One of the easiest ways to do a mail merge in Gmail is to use a Gmail add-on that's can perform mail merges.

The following add-ons are all fairly straightforward to use, and all of them have a free plan:

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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