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 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 a mail merge in Gmail with 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 to this and don’t know how to get extensions for Google Spreadsheet, then this link is for you.
Send Mass Email in Gmail
It allows sending a 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 your 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.
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 a 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“.
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 a few mins back.
Step 8. Now this will import all your contacts in the Google Spreadsheet just in a blink.
Step 9. Our contacts are already imported, so now it’s time to add 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.
As you can see in the above image we send emails to 45 recipients with a free version and to send more than 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.
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.
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. Alternatively, you can also use some bulk email sender software too.