App Icon
Digital Inspiration
•  3,773,805
Overview
Send personalized emails with Gmail Mail Merge. Include different file attachments, schedule emails for sending later, CC and BCC support, track email opens, clicks, and bounces messages.
Send personalized email messages to your contacts with Mail Merge for Gmail. Each email message is unique and, unlike putting email addresses in the CC or BCC fields, every recipient will receive your intended message as if it were sent solely to them. Email tracking will help you know when people have read your email.

You can use Gmail Mail Merge for sending mass emails easily. Send holiday greetings (with emojis), event invites, school assignments, press releases, schedule birthday messages in advance, create rich email newsletters or reach existing customers with any upcoming offers in your store.

Mail Merge works with Gmail and GSuite accounts. You can send merged emails immediately or use the built-in scheduler and send emails at a later date and time.

You can compose email templates inside Gmail or use the built-in visual HTML editor to create rich text emails using HTML and CSS. Gmail now supports media CSS queries in addition to inline CSS styles.

Mail Merge supports email aliases so you can send emails on behalf of someone. For instance, your office secretary may perform mail merge but send emails from your own Gmail account.

Mail Merge for Gmail is currently being used by organizations to quickly send email updates to employees who are working from home during the Coronavirus (COVID-19) crisis.

--------------------
Mail Merge Features
---------------------
➩ One-click importing of Google Contacts for sending personalized emails
➩ Insert different file attachments for each email recipient.
➩ Included emojis and animated GIF images in the message body and emoji in the subject
➩ Skip sending emails to rows that are hidden in the sheet or filtered.
➩ Upload files from your computer or select existing documents from your Google Drive
➩ Send merged emails immediately or schedule messages for sending later.
➩ Automatically CC or BCC every email message to your CRM or any other email address.
➩ Send emails on behalf of any other email address that is configured as an alias in Gmail.
➩ Write your messages in plain text, rich HTML, or use an existing Gmail draft as and email template.
➩ No Mail Merge branding included in email footer [Premium]
➩ Rich text formatting of spreadsheet cells preserved in emails [Premium]
➩ Automatically create drafts in Gmail from Mail Merge [Premium]
➩ Track your email opens  (read receipts) and clicks on links  [Premium]
➩ Add an unsubscribe link to your email campaigns, view unsubscribes report  [Premium]
➩ The email bounced reports show messages that were not delivered [Premium]
➩ Give your contacts an option to unsubscribe from your mail list [Premium]
➩ Embed QR Code and Barcode images in email messages [Premium]
➩ Send a test email to verify your Mail Merge campaign setting before sending the email blast to all recipients
➩ Set the Mail Merge Status column to SKIP if you would like to skip merging certain rows in the current batch.

The email subject line and the message body can be personalized for each recipient. Email messages can also be CC'ed or BCC'ed to one or more people.

You can include different attachments from Google Drive for each person and the email messages can be either in plain text or include rich-text (HTML) formatting. You can write the emails in HTML directly inside the Google Spreadsheet or you can create a draft message inside your Gmail account and use that as a template for Mail Merge.

The email opens can also be tracked with Google Analytics. The Mail Merge program adds a 1x1 tracking image to the message body, similar to other solutions like Sidekick, Hubspot, Streak, and Yesware mail trackers, and if the recipient has enabled image downloads in their email client, the open activity is recorded.

Mail Merge can import Google Contacts into the sheet so you don't have to manually type the email addresses of your contacts. If a person has multiple email addresses, the Merge app gets the primary email address and if not available, it gets the Work email or the Home email.

Each message you send out has the same information but certain parts of the email are unique and each person in the mailing list is addressed individually.

Mail merge is universal but have different names in different languages -  دمج البريد, fusión del correo electrónico, 差し込み, മെയിൽ ലയനം, 邮件合并, fusion et publipostage, Seriendruck, מיזוג דואר, слияние почты, mala direta, จดหมายเวียน, unificación de correo or stampa unione.

How many emails can I send per day?
------------------------------------
All Mail Merge users can send 25 email recipients per day. You can upgrade to Premium Edition https://digitalinspiration.com/buy to increase your daily email quota.

Go to the Google Sheet > Add-ons > Mail Merge with Attachments > Show Email Quota to know your daily email quota that will be available after you upgrade to Mail Merge Premium. The quota is:

Mail Merge (Premium) for Gmail Accounts - 400
Mail Merge (Premium) for Google Apps for Work - 1500 (only available to paid Google Apps for Work accounts on Apps domains that are a few months old). You need a Mail Merge license to use the 1500 limit.

Google will automatically reset your daily quota around 1 PM PST.

Attachment Size Limits
---------------------------
For email drafts, the maximum attachment size limit is 15 MB.
For email messages, the maximum file attachment size is 15 MB for Google Apps, GSuite, and Gmail accounts.

If you need to insert bigger files with your Gmail messages, you should upload the file to Google Drive, create a shared link and insert that link into your email message body.

Date and Time Formatting
---------------------------
If you have columns in your Google Spreadsheet that contain date and time, you should format the column as text (right-click the entire column, go to Format -> Number -> Plain Text).

Alternatively, use the =TEXT() formula to display the date and time in the desired format.

For scheduled date column, format it as date and time as described in this tutorial:
https://www.labnol.org/mail-merge-scheduled-date-time-11152

Mail Merge Resources and Tutorials
------------------------------------
➩ YouTube video tutorial: http://youtu.be/F07Py7sraDg

➩ HTML Emails in Gmail: https://youtu.be/ZSSqsEVsChc

➩ Mail Merge Tutorials: https://digitalinspiration.com/docs/GA01

➩ Email Sending Limit: https://www.labnol.org/gmail-sending-limit-7048

➩ Email Open Reports https://www.labnol.org/gmail-email-opens-7080

➩ Send email from a different address https://www.labnol.org/send-emails-from-alias-7158

➩ Upgrade to Mail Merge Premium: https://digitalinspiration.com/buy?sku=GA01

Release Notes
---------------
12-September-2020 - Embed dynamic QR Codes and Barcodes images in email messages using the QRCODE and BARCODE functions. The daily email limit for free users is changed to 25.
30-August-2020 - Rich formatting of spreadsheet cells is retained in email messages. The HYPERLINK formulas of Google Sheets are transformed into HTML hyperlinks in email messages. Requires Mail Merge subscription.
25-August-2020 - Added support for rich text fields and multi-line cell values. If a merged cell in the spreadsheet contains hyperlinks, bold or italic text, and font colors, the formatting is now applied in the message body of emails as well. Also works with Conditional Formatting in Google Sheets.
13-May-2020 - Added option to resubscribe email addresses that have unsubscribed from Mail Merge by accident, Improvements to Google File Picker to disallow large files that cannot be sent as Gmail attachments
10-May-2020 - Mail Merge 16.0 is a major release with big improvements to email scheduling and email campaign reports.
05-Apr-2020 - Old campaign reports retired, added support for importing MailChimp contacts into Gmail mail merge.
17-Feb-2020 - [Major Release] Upgraded to V8 Runtime, Improved Email Tracking, and Campaign Reports, Bug Fixes
10-Sep-2019 - Fixed an issue with importing Google Contacts into Google Spreadsheet for Mail Merge
06-Sep-2019 - The annual Security Assessment mandated by Google has been completed. Mail Merge is now verified and 100% compliant with Google API policies.
26-Jan-2019 - Fixed an issue around creating drafts in Gmail.
15-Nov-2018 - Fixed an issue with certain Gmail drafts not showing up in the template list. This issue was related to drafts that were created from existing email messages through forwards or replies.
01-Nov-2018 - Do not send merged emails to rows that are hidden in the Google Sheet or filtered by the user.
22-Oct-2018 - Added inline renew and checkout option for easy license renewal. Bug fixes. Added an option to restore license for new Google sheets.
28-Sep-2018 - Improved debug logs for troubleshooting, resolved issue related to Gmail drafts not getting pulled in some cases.
11-Sep-2018 - Format the Scheduled Date column as Date Time to remove incorrect formatting errors.
30-August-2018 - Introducing WYSIWYG editor to create beautiful emails visually or code directly in HTML. Include emojis in the email message body and subject lines. Insert one or more attachments from Google Drive into your emails with Google File Picker. Visual enhancements.
24-August-2018 - Improved checkout workflow, UI enhancements, bug fixes.
17-August-2018 - Rolling out a new layout for mail merge configuration window, new option to select Google sheet that contains data for merging. New checkout workflow.
14-August-2018 - Welcome onboarding email sent to new users with links to docs and tutorials.
10-August-2018 - Improved support for Filters in Google Sheets. Mail Merge does not send emails to filtered rows. You can include Google Sheets, Google Documents, and Google Slides in your Mail merge campaigns and they'll be sent as PDF file attachments.
08-August-2018 - Insert emojis in Mail Merge subject and email body. Added support for new Gmail and Google Inbox. Email sent via Mail Merge can now be opened directly from the Google Sheet. MIME message parser enhanced to include attachments and inline images for new Gmail.
29-March-2018 - Added extra check for invalid email addresses in the sheet that may prevent mail merge from sending emails
15-Jan-18 - Google add-ons may not work if a user is logged into multiple Google Accounts at once. Added check.
14-Nov-17 - The addon may require reauthorization as Google has added new UI scope for addons that embed external JavaScript libraries (like jQuery or Google Analytics) in sidebars and dialogs.
08-Nov-17 - Added option to do a factory reset and de-authorize the addon.
27-Sep-17 - Added support for Google Spreadsheet filters. Only the currently visible rows are processed for Mail Merge.
01-Aug-17 - Improved file attachments module, better handling of network connection issues.
05-Jul-17 - Included check for duplicate columns in the Mail Merge sheet.
06-Jun-17 - Bug fixes and minor enhancements. Improved documentation.
09-May-17 - You can now send large HTML emails using the code generated from htmlmail.pro
22-Feb-17 - Improved mechanism for tracking email bounces and undelivered messages after Gmail updated the format for mailer-daemon emails.
26-Jan-17 - Removed legacy email campaign reports, open URL tracking
20-Jan-17 - Mail Merge now checks your template variables for any errors before sending emails. Updated documentation at j.mp/MailMergeTutorials. Bug fixes related to click tracking inside Mail Merge.
31-Dec-16 - Final release of 2016. Contact support directly from the Mail merge window. Priority support for premium customers.
17-Dec-16 - View unsubscribes and bounced email messages in a neatly formatted report.
05-Dec-16 - Fix for email addresses that are not treated as aliases in Gmail. Both plain text emails and HTML emails are now supported. Improved Error logging and debug logs.
28-Nov-16 - Significant update. Track clicks on links, add unsubscribe links to outgoing messages, send emails automatically after the quota is reset, insert files in the email from your computer. Performance enhancements.
07-Nov-16 - Added checks for empty sheet before configuring Mail merge. Fixes for empty lines HTML mail. Added https://htmlmail.pro for creating responsive HTML Mail with Gmail Merge.
20-Oct-16 - Mail Merge Open report upgraded to include the full date and time stamp.
08-Sep-16 - Privacy policy included. Become a mail merge expert, read our tips and tutorials at https://digitalinspiration.com/docs/GA01
04-Aug-16 - It is now possible to skip certain rows from merge by setting the status column to SKIP. Test Email messages now include file attachments from Google Drive.
30-Jul-16 - Enhanced functionality to import Google contacts email addresses into Mail Merge. Added option for one-on-one support for Skype or Google Hangouts. Test Emails now include more debugging information.
20-Jul-16 - Fixed issue related to Document missing. If the spreadsheet template cannot be loaded, Mail Merge creates a blank spreadsheet template with no formatting.
02-Jul-16 - Fixed "Cannot Connect to Gmail" issue related to Gmail Drafts. The Email Tracking report now sorts Mail merge campaigns by send date for quick access.
03-May-16 Added option to restart the email scheduler if the cron job stops for an unknown reason.
18-Apr-16 Added unlimited (team) license for admins to deploy Mail Merge for all users of a Google Apps domain.
7-Apr-16 Google resets emails quota at 2-4 PM PST. Currency, Number, and Date formatting preserved in outgoing email messages.
Reviews
Language:
Sort by:
Profile Picture
A User of Mail Merge with Attachments
September 28, 2020
cannot see it on my mac
Is this review helpful?
Yes
No
Profile Picture
A User of Mail Merge with Attachments
September 27, 2020
I am very disappointed. It says that I installed this app, however, it is nowhere to be found in my google docs. I am concerned because I had to give permission to everything in order to download it and yet, I am unable to use it. I am uninstalling from the tab shown on the same page where I downloaded from, but, truly have no idea where to find the actual app in order to begin using it.
Is this review helpful?
Yes
No
Profile Picture
A User of Mail Merge with Attachments
September 26, 2020
I have several g-suite accounts and use Digital Inspiration products on all of them. The apps are great, useful, and very user friendly. The time I have saved is worth any amount to me. Would not hesitate to use anything this group puts onto the Marketplace. Have a question? Their Customer Support is phenomenal!
Is this review helpful?
Yes
No
Profile Picture
Sagar Juneja
September 26, 2020
I am using this mail merge for last three years. Today I am getting a unique error while selecting a GMAIL Draft (Email Template). It is giving me error that mail body is too big for GMAIL to send. Never received this error before. I also tried with one word Test mail draft but still getting the same error.
Is this review helpful?
Yes
No
Profile Picture
A User of Mail Merge with Attachments
September 25, 2020
You rock!!!
Is this review helpful?
Yes
No
Profile Picture
Kate Durden
September 25, 2020
I really liked this add-on, and it was super useful. As a teacher, I am constantly sending mass emails to my students with just a few things different, which is tedious work. I used the free version for several months and sent out logins and progress reports (love the attachment feature!) with ease, in a fraction of the time it used to take me. However, today I went to send out some login information to my students. There are 89 of them, so I figured I'd send the first half today and the second half tomorrow. They've lowered the daily free quota to 25 from 50, which is very disappointing. It would take me 4 days to send out emails to my students. I get that they can't just give their business away, but to decrease by 50% to 25 just seems like they don't want anyone using the free version. How often would you send to just 25 people? Much lower than that and you can just make the emails yourself. But, I thought, I'll go ahead and buy it. I use it enough. It was $3.25 a month, which is more than reasonable. I didn't want to pay yearly (again, teacher, tight budget). I went to pay monthly, and expected an increase in price to something like $5.00. IT IS $19.99 A MONTH FOR ONE USER IF YOU PAY MONTHLY. I don't understand how much it costs for hosting and sending all these emails everyday, but to change from $3.25 to $19.99 seems arbitrary. Not to mention the free version is 25 emails and the paid is something like 1500. I give it 5 stars for function but 1 star for business practice.
Is this review helpful?
Yes
No
Profile Pciture
Jared Martin
September 25, 2020
If you want a free mail merge that is unlimited you could try autocrat. It's probably not as user friendly and it doesn't track emails but I use it daily to notify parents when students don't complete their homework.
Profile Picture
A User of Mail Merge with Attachments
September 24, 2020
Great tool!
Is this review helpful?
Yes
No
Profile Picture
A User of Mail Merge with Attachments
September 24, 2020
This program has been extremely useful for my company. I am able to efficiently send customized emails.
Is this review helpful?
Yes
No
Profile Picture
A User of Mail Merge with Attachments
September 24, 2020
Just got it and it saved a bunch of time. Worth it for the few times a year I will use it.
Is this review helpful?
Yes
No
Profile Picture
A User of Mail Merge with Attachments
September 23, 2020
The add on is an excellent productivity tool and am a regular user of this feature almost as frequent as daily. Unfortunately, though i understand fully and support the business sense of the logic, the daily quota of 50 free mails have been reduced to 25 which is a dampener for folks like me running for a free app. Otherwise, it is an excellent tool for mass mailers and will recommend to buy this with 400 emails daily quota.
Is this review helpful?
Yes
No
1-10 of 103
Additional information
Digital Inspiration
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu