Take the 2-minute tour ×
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

2 Answers 2

Labnol has a video tutorial and walkthrough.

The key is that:

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

Update

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

share|improve this answer

Your Answer

 
discard

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.