Mail Merge

Mail Merge

Best Overall

Back to all apps

Overview

Easiest mail merge add-on in the market. No sign-up required. Free and fast customer service. Free from advertising or watermarks.

Summary

Easiest mail merge add-on in the market. No sign-up required. Free and fast customer service. Free from advertising or watermarks. HOW IS THIS ADDON USEFULWhether 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 or meetup (using apps such as Zoom, CISCO Webex, Microsoft Teams, etc.)➤ Generate certificates or application forms. Each document/form can have its own image (such a profile picture).➤ 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 presents the latest blog posts➤ A newsletter solution to send periodic newsletters on your latest products, features, promotion, discount, coupon, news, reports, metrics or 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 and generate new leads for sales people. ➤ Generate and print envelopes. Make each envelope unique to each recipient. You’ll find that this MailMerge 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), mail merge for gmail, Gmerge, Autocrat or Mailmerge & Scheduler. NEED HELP AND SUPPORT?Don’t worry. We don’t use robots with artificial intelligence. We have real intelligent people answering your questions with an average response time of less than 3 hours. However, we usually reply much faster than that. Whether you are using the free or premium version, we do not charge for customer support. Help comes in the form of email communication, or as an alternative, we also provide a remote desktop session.We offer a 30 day MONEY BACK GUARANTEE. We pride ourselves on having the best customer care.You can also help yourself by searching our FAQ (Frequently Asked Questions):https://mms.quicklution.com/help If you don’t find the answer feel free to contact us here:https://mms.quicklution.com/contact-usWHAT 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 the 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.INTRODUCTORY VIDEOIf you feel that the add-on is not intuitive and easy enough you can quickly watch this step-by-step tutorial on YouTube https://youtu.be/0uAOUnao2b8 HOW TO MAIL MERGE - Using the Google Doc add-on➤ Write your GDoc template. This will serve as a base for your email body or letters.➤ Start the add-on by clicking Add-ons->Mail Merge->Start.➤ Click “Open Spreadsheet” to choose a Google Sheet file from which you want to merge data. This can be any file from you Google Drive, Team Drives or from other Google Drive you have access to.➤ Select the sheet tab you want to merge data from.➤ 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|* when you design your label.➤ Insert merge fields into the Google Document template. Merge fields are the column name found in the first row of the data in your Google Sheet.➤ You can change the font color, size, etc. of the merge fields as well as regular text. You can further customize it by adding images.➤ When you are ready press the blue Merge button to start the mail merge process.➤ 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.➤ If you are merging to Letters you can opt to merge everything in a single Google Doc or create a Google Doc for every row you want to merge.HOW TO MAIL MERGE - Using the Google Sheets add-on➤ Start the add-on from Google Sheets ->Add-ons->Mail Merge->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 abc@quicklution.com, xyz@quicklution.com.➤ Enter the Email Subject, such as ‘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 are 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.ADD-ON HIGHLIGHTS - Available for the Google Doc and Sheet add-ons★ Personalize your email message body and your subject line to send unique emails to recipients in bulk/mass.★ Opt to merge only selected/filtered rows of data.★ 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.★ Track which rows have been merged.★ Mail Merge Images. Automatically replace *|Merge Fields|* with images. Ideal for QR Code, Barcode, profile photo, etc. https://mms.quicklution.com/help/mergeimages★ No limit to how many emails you can send.★ No limit to how many merge fields you can enter.ADD-ON HIGHLIGHTS - Available only for the Google Doc add-on★ Add a different CC / BCC to each email sent.★ Set a reply-to email.★ Send Emails on behalf of other accounts.★ Send emails over SMTP. Ideal to send emails from non-gmail accounts such as Yahoo!, Microsoft, SendGrid and many more.★ Schedule a campaign for a certain date and time.★ Send the document template as a PDF attachment to your emails.★ Add image merge fields so you can have a different image in every email/letter you generate.★ No limit to how many documents you can generate. PRICING / COSTUsed from Google Sheet: Totally Free. With unlimited emails per day. Enjoy!Used from Google Docs: After the free trial you can purchase a $30 year license or a $80 lifetime license. TRANSITION TO G SUITEWas 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 a mail merge from Excel. This extension can be used from your Chromebook, Mac, Window or any other platform with a browser. It makes your move to Chromebooks easy! PRIVACY POLICYThe 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. Quicklution is also bound by Google to keep this restrictive policy. To learn more about this and why certain permissions are required please view our privacy policy page: https://mms.quicklution.com/help/terms OTHER INFORMATIONMail 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