Send personalized emails by getting data from a Google Sheet. Free and no limit to emails/day.
Easiest mail merge add-on on the market. No sign-up required. Content generated is free from any advertising.
No bots or AI. We have real people answering your questions with an average response time of less than 3 hours. However usually we reply much faster than that. We offer free support to everyone. It's a pleasure to help you and we welcome feedback to make our product better.
WHAT DOES ‘MAIL MERGE’ MEAN?
Mail Merge is a powerful tool for writing a personalized E-mail to many people at the same time. It uses data from GSheet and then uses that to replace placeholders/merge fields throughout the message with the relevant information for each individual that is being messaged.
HOW TO MAIL MERGE
➤ Start the add-on from Google Sheet ->Add-ons->Mail Merge for Gmail->Start
➤ Make sure the first row in your sheet contains column names. Such as ‘Fullname’, ‘Address’, ‘Email’, etc.
➤ To be able to merge you need to have at least one row of data under your column names.
➤ These column names will be used as *|Merge Fields|* into your email body and subject.
➤ From the Sidebar Select the Sheet tab you want to merge data from.
➤ Select the ‘Email To Column’. This will be the column in your sheet which contains a list of email recipients. Typically this is a column name called ‘Email’. All values in this column must have valid email addresses (except the column name of course). You can enter multiple email addresses in the same cell. They can be separated by a comma, semicolon, etc. Such as email@example.com, firstname.lastname@example.org
➤ Enter the Email Subject, such at ‘Exam Results for *|Fullname|*’
➤ Click the ‘Email Body’ link so you enter some content into your email body. The content can include merge fields such as: Dear *|Fullname|*,
➤ Once you save your email body, you can start by testing your merge. Click ‘Test Email’ and hit the blue Merge button. The test merge will merge data from the 1st row of data. That is row 2 since row 1 only contains column headers.
➤ Once you’re happy with how your email looks you can go ahead with a full merge. You can either send emails straight away or merge to Gmail’s Draft folder. The latter will give you an opportunity to change and verify the emails before you send them.
➤ A column called ‘Mail Merge Status’ is automatically created for you by the add-on. This will be automatically populated with the date and time the row was successfully merged. If you want to re-send/merge the row, just delete the content of that cell under the ‘Mail Merge Status’ column. If there is text in all the data rows for the ‘Mail Merge Status’ column you will get an error when you attempt to merge telling you that there are no rows to merge.
★ Personalize your email message body and your subject line to send unique email to recipients.
★ Send a test email to get a good idea on how it will look like.
★ Before sending emails it's best to merge to a ‘Test Email’. This will give you a good idea of how the email will look to your recipients.
★ Instead of sending emails straight away, you can opt to merge emails to your Drafts Folder. This will give you the opportunity to check and edit the emails before you send them.
★ Opt to merge only selected/filtered rows of data.
★ No limit to how many emails you can generate.
★ No limit to how many merge fields you can enter.
★ Track which rows have been merged.
QUESTIONS? NEED HELP AND SUPPORT? CONTACT US
HOW IS THIS ADDON USEFUL
Whether it’s for personal or professional use, this is a simple and powerful tool which fits every purpose.
➤ Inviting people to an event such as a webinar, wedding, job-dating, fair, conference, meetup.
➤ Get answers from a large list of guests and invitees.
➤ Get potential new clients with a custom email campaign.
➤ Drive and generate new leads with efficient cold emailing.
➤ Send commercial offers suited to each recipient.
➤ Apply to many job offers at once.
➤ Manage PR campaigns by contacting journalists or influencers.
➤ Send payment reminders to a list of clients with their invoice attached.
➤ Share information on each student with their parents the easiest way.
➤ Greetings for birthday, happy new year, new year's eve wishes, holidays, thanksgiving, halloween, secret santa, christmas, xmas holiday to your friends, family or colleagues.
➤ Renew your audience commitment to your blog with an email that present the latest blog posts
➤ A newsletter solution to send periodic newsletters on your latest products, features, promotion, discount, coupon, news, reports, metrics, polls.
➤ Address personalized thank-you emails to HR recruiters, crowdfunding supports, product hunt upvoters, business angels, a friend or family.
➤ Run efficient cold emailing or follow-up campaign to drive & generate new leads, for sales people.
You’ll find that this Mail Merge add-on is simpler and easier to use than: Yet another Mail Merge / YAMM, Gmass, Mailmeteor, Mixmax and to other solutions like FormMule (or Form Mule), Gmerge, Autocrat or Mailmerge & scheduler.
PRICING / COST
Free, Nothing, Nada, Totally Free. With unlimited emails per day. Enjoy!
TRANSITION TO G SUITE
Was it hard to switch from Microsoft Word to Google Docs because it didn’t have a mail merge add-on? Quicklution is here to help you make the transition from Microsoft to GSuite as smooth as possible.
This add-on combines the power of Google solutions to replace mail merge solutions: Microsoft Mail Merge (also known as MS mail merge, MS Word mail merge, MS Word's "envelopes & labels", MS wizard, Mail merge Excel), Mail merge Libreoffice / Libre Office, Pages and Numbers mail merge. Now you can mail merge from Google Docs, Google Spreadsheet and Google Drive instead of mail merge from Excel.
This extension can be used from your Chromebook. It makes your move to chromebooks easy!
The data processed by the add-on is NOT stored or transmitted to anyone for analysis. Not even by Quicklution. Your data stays with Google.
Quicklution complies with privacy laws such as GDPR & California Privacy Act to protect your data.
Mail merge translates to: seriendruck | combinar correspondencia | combinación de correspondencia | Stampa unione | e-merge | fusion et publipostage | دمج المراسلات | 邮件合并 | מיזוג דואר | 편지 병합 | слияние почты | वीडियो: मेल मर्ज | Google Drive Mail Merge | Google Docs Mail Merge | Google Sheets Mail Merge