Are you seriously so fed up of having to send all those important personalized emails manually to several dozen people? Look no more! Mail Merge offers pretty much everything varying from importing contacts from Gmail to having the superiority to send the emails at any particular date, and many more.

About Mail Merge - Google Sheets add-on

The Mail Merge tool is designed thoroughly to slay the complexities of sending emails and newsletters or any other form of valuable documents without having to waste any time or energy in sending emails to every single recipient manually.

The user could send merged emails at any precise time convenient to him, and the cherry on the top is, that there is absolutely no trouble of possessing knowledge of HTML. In other words, a rookie can also handle and manage tens or hundreds of emails, thanks to the regard of Mail Merge.

Mail Merge Features

Import contacts from Google

Import contacts

The process of taking each contact out, one at a time, is pretty elusive and time-consuming. Even the idea of having to forward a single email time and again to multiple different contacts is brutal. Mail merge, however, offers the most simplified feature of importing contacts from Gmail or Google, thus making the task of choosing recipients in quick mere seconds.

In case some of your desired recipients are not synced to your Google account, then there’s always an option of copy pasting the contacts manually from a spreadsheet or a CSV file.

Compose message text in a visual editor or import a Gmail draft

Gmail draft or visual editor

Either the user can import the already existing drafts from Gmail, and if not, then mail merge offers its rich visual editor in which you can customize the text, the alignment, the background and many other specific features for adding more texture. There’s also an HTML editor for the more geeky ones who can write HTML and need more control.

Attachments

Personalized attachments

One of the top most features of mail merge is, of course, its ability to attach personalized files in such an undemanding way that it makes it a matter of just mere seconds. Through adding a new column in the spreadsheet, the user can either attach the file of any format, from Google drive by simply copy pasting the Google Drive URL of the desired file in the ‘attachments’ column.

Cc and Bcc recipients

Personalized CC, BCC

Mail Merge provides the facility to add Cc and Bcc recipients. By immediately adding new Cc and Bcc columns in the spreadsheet, joining more personalized recipients appears to be just like a cake walk. This feature is quite handy when you need to mark each email to a separate person for review or for information.

Send merged emails immediately or schedule at a specific time

Send now or Schedule

Mail Merge users as it allows to send mails at whenever time that is preferable and suits the sender. After the user enters the date and time, Mail Merge automatically delivers out the email at the particular time and day set by the user.

Multiple email sender options beyond Google

In an upgradable Mail Merge service, an additional three more external email senders, in addition to the default Google one are allowed. The user can choose from which sender to deliver the email among the others. As this is a Google Sheets add-on, you are by default restricted by Google enforced daily sending quota (of 1500 emails for G Suite and 100 for Gmail) when sending emails. But this upgrade of Mail Merge provides the user the option to use external senders (like SparkPost, Mailgun or Elastic Email) in addition to the default Google sender. The user can alternate between these four email senders, according to his convenience to deliver up to 20000 emails per day.

Opened tracking for email in real time

Google Analytics

Mail Merge lets you add your Google Analytics code and tracking parameters to each email. This lets the user track email opens in real time using Google Analytics.

Other useful features

Throttle your email blast across multiple days if it is larger than your daily sending quota
Retain data formats from your sheet (like currency, dates)
Test send email before sending actual campaign
Skip merging and sending certain rows in the current batch
Variable repeater merge fields that let you make bullet lists or tables in Mail Merge

How to Use Mail Merge with Google Sheets

Here's a detailed video tutorial on using Mail Merge

Mail Merge - Google Sheets add-on is available in the Chrome Web Store. Install it from there.

Are you seriously so fed up of having to send all those important emails manually to several dozen people, one at a time, and looking for a cheap plus modest but an efficient solution? This tool is accurately a magical wand for its users. It offers pretty much everything for the sole purpose of simplification and flexibility to its users. Varying from importing contacts from Google to having the superiority to send the emails at any particular date, there is literally nothing left out by Mail Merge. Mail Merge has got the whole lot, which from a businessman to a student, everyone requires.