How to send a mass email to personalized email ids using Gmail.

Hii all.

Here in this post, i will explain you how one can send a mass email to personalized email accounts. For example you wish to invite around 50 people to any event/party. You want to send an invitation email to all of them addressing them with their respective names and also including some other respective information related of each individual. In that case with the database of email ids with you, it is not necessary that you send the same email each and every time to each one by editing the content of the mail wherever required.
A small example can be like this,

"Hii 'Prudhvi' from India.

How are you. I hope you are doing well.
By this email, I would like to invite you to my birthday party on 15th of this month. "

Now to send the same email to someone else you need not write the whole content and change the name of the person. Instead you can use the database that you have with you and with the help of mail merge, you can actually send personalized emails to around 100 people per day. We shall discuss the procedure of this with an example related to the same. The picture below depicts the database that you are intended to use.

First Step :-

Setting up of the email message. In this step you have to set up the email content that you would like to send. For instance, the first line of your messages could read Hii First-Name and you need a way to tell Gmail that First-Name is a variable field. This can be done by replacing First-Name in the message with $%First-Name% as shown in the following picture.
In the similar fashion, replace all variable fields that are either in the body or the subject line of your Gmail message. At the end, save this email as a draft message.

Second Step :-

Setting up the database. Once you are done with setting up the email message as described in the aforementioned step, you have to open your database in a google spreadsheet if you have it from beginning or else you have to create a google spreadsheet. A typical example of the same is shown below. Please note that the you just need to change the column names in the spreadsheet such that they match the various variable fields that you have marked in your Gmail draft message.
You can add (or remove) any number of columns but the one mandatory column that should exist in your spreadsheet is labeled Email Address. Just ensure that the column names in the spreadsheet and the variable fields in the Gmail messages are exactly same and that every Gmail variable is mapped to a column in the mail merge spreadsheet.
You need to have one row of data in the Google Spreadsheet for every recipient and the values of that particular row will be used to send a personalized message to that recipient. 

Third Step :-

After setting up the database sheet with all the required data and in the way as explained in the second step, go to the Mail Merge menu in the Google Sheet and click Initialize to authorize the program. After this choose Start Mail Merge from the same menu and choose the Gmail draft template you created earlier from the drop-down. Check BCC if you want to get each mail BCC ed to your email account. At the end click on the Mail Merge. After successful merge, you will get a new column added to your spreadsheet with values EMAIL_SENT which indirectly confirms that the emails were sent to the respective accounts.
Screenshots of the example which we are discussing are below. You can observe them in case if you didn't understood any point in between.

This completes my post. I hope that this post was useful to you.
Please fill in your email address in the "Follow me" field to get my future posts directly to your email account.