September 19, 2014

How to Create Mail Merge with Gmail and Google Docs

Mail Merge in Gmail allow you to send personalized messages to multiple people in one go. Individual message will have same content but you can customize some part of message. For example you can change the name  and postal address or person and still message stay same in text body.


Mail merge in Gmail : eAskme
How to Create Mail Merge with Gmail and Google Docs : eAskme

HTML Mail Merge with Gmail

Mail merge option available in premium and free editions.


FeaturesFreePremiumPremium+
Works with Gmail & Google Apps      Yes     Yes                          Yes
Can include BCC  or CC addresses      No     Yes                          Yes
Send emails through an alias      No     Yes                          Yes
Track outgoing messages with Google Analytics      No     Yes                          Yes
Include personalized file attachments      No     Yes                          Yes
Specify a different Reply-to address      No     Yes                          Yes
Installation Manual (PDF) included      No     Yes                          Yes
Support optionsSupport Forums  Email Support  One-to-one support over Skype or  Google Hangouts

You can purchase this service by making payment through credit cards and debit cards or Paypal.

How to do Mail Merge with Gmail :

Mail Merge in Gmail  allow you to send richtext emails to multiple contacts same time.

  • Click Here  to create mail Merge in Google Drive. Mail Merge iinternally use Google Apps Script.
  • Go go "Mail Merge", Click on the "Reset" to clear canvas and authorize sheet to access Gmail and Google contacts.
  • In Google Contacts, create new group with contacts on those you wish to send personalize email or you have to enter names and email addresses manually in Google sheet.
  • Under Mail Merge menu, select Import Google Contacts and choose Google Contact group you have made. Ths will import all contacts of that group.
  • Fill fields of email template.
  • Compose an email template using HTML mail tool and copy the code and paste it into message body of Google Sheet.
  • You can also upload any file in Google Docs that you want to send and copy the Id and paste it in aattachment ID field. ID will show in URL.
  • Go to Mail Merge and click on "Start Mail Merge". Statues will change to "Ok" for those emails that are successfully delivered.

You can daily send maximum number of 100 messages., as it is the limit of Gmail. You can also send Personalized Emails using Mail Merge in Gmail.

For more Google tips and tricks visit Here 

Do share your own tips about "Google Plus".