Create Mail Merge In Gmail With Google Spreadsheet To Send Mass Emails

Mail Merge Gmail is one of the coolest Add-on I have used so far. The reason I am saying this because it allows you to send emails directly through the Google Spreadsheets.

Can you believe it, Google Spreadsheet which is most easier to use, and very user-friendly, and now it will be allowed to send emails as well.

Mail Merge Google Chrome extension allows to create mail merge in Gmail with an ease and send it in a few simple steps.

How does that happen..? Let see that…!

Create Mail Merge In Gmail With Google Spreadsheet

Mail Merge feature is not available in Gmail by default. Fortunately, this extension is designed by “Digital Inspiration which is being very useful and we can get it from Google Chrome Webstore.

So here we got an opportunity to use mail merge with Google Docs directly and free. And moreover, it can be performed quicker and will have full control over your sent emails.

If you are new into this and don’t know how to get extensions for Google Spreadsheet, then this link is for you.

Video Credits: Amit Agarwal

Send Mass Email in Gmail

It allows to send mass email with Gmail itself in just a few clicks. It is very useful for those who send emails daily to multiple people.

And this will be going to save some extra time, and one can be more productive. All the Bulk emails can be sent in one click.

And moreover, you can personalize the body content and attachments to any particular recipient.

Multiple Gmail Contacts can be added to the Google Spreadsheet by using this Mail Merge extension by creating a group of Gmail Contacts. So it is always a better idea to import the group of contacts in just a few clicks, instead of a copy – paste job.

Now Let us get into action and get this job done and create Mail Merge in Gmail with Google Spreadsheet.

Step 1. Login To you Gmail.

Step 2. Navigate towards your Contact Section, and form a group of those recipients whom you want to send mass emails. Check out the below image for better insights.Mail Merge In Gmail With Google Spreadsheet

Step 3. Now though we have already created a group in Gmail, Open a New Google Spreadsheet from Google Drive.

Step 4. Now we need to install the extension, here is the add-on created by CTRLQ Go through that link and click on install. This will create Mail Merge extension for your Google Spreadsheet.

Step 5. Go to Add-Ons menu and click on “Create Merge Template”, this will create a Mail Merge Template in your Google Spreadsheet.

Step 6. Now click on the Add-ons menu and the “Import Google Contacts“.

Mail Merge In Gmail With Google Spreadsheet
Step 7. This will Open a Dialog Box, from where we can import the contacts, select the group which we have created as a group in Gmail few mins back.
Mail Merge Gmail

Step 8. Now this will import all your contacts in the Google Spreadsheet just in a blink.

Step 9. Though our contacts are already imported, so now its turn of adding some attachments, which we want to send in the email to any recipients.

The good thing is, it is not compulsory to send the same attachments to all the recipients. Attachments could vary for all the users.

All we have to do is copy a link to the file in the section of that particular recipient. Or there is also an easy way to do this.

Select Add-on – Mail Merge with Attachments – Add File Attachments

Now we will have three options to import the attachment, choose one from where you want to import the files.

Step 10. Now the next is Schedule Section, here we can schedule the emails we want to send. Can be done by just by mentioning a day and time in the required field. Though it is not compulsory if you want to send the emails instantly after composing the email.

Step 11. Now it is time to send the Email, to do that let us compose an email by again going back to the

Add-on menu – Mail Merge with Attachments – Configure Mail Merge.
A dialog box will open, there we can add some CC and BCC as well if required.Mail Merge gmail

As you can see in the above image we send emails to 45 recipients with a free version and to send more 250 emails per day, we need to upgrade to the premium one.

Step 12. Click on Continue.

Step 13. It will take you the next dialog box where you have to compose the email body and few details.Mail Merge

Step 14. Once done by writing the email, Click on “Run Mail Merge” to send the emails to all the recipients. It will just take few seconds and Bingo all the emails forwarded to the recipients.

You will also be also to see the confirmation message in the Google Spreadsheet.Mail merge gmail

As we can see in the image, the Mail Merge Status, the sent date and time as well. I hope this helps, do let us know if you faced any issue in that in the comment section below.

6

Don't Hesitate, Leave a Reply...!

Notify of
avatar
wpDiscuz
Questioncage

Subscribe To QuestionCage

Glad to see your Visit at QuestionCage!

One more step to connect ahead "Subscribe to Us" and get the updates to your inbox directly.

You have Successfully Subscribed to QuestionCage!

Share
+1
Tweet
Share
Pin