Content generated is free from any advertising or marketing. No robots or AI. We have real people answering your questions with an average response time of less than 24 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. HOW DOES THIS MAIL MERGE ADD-ON WORK? ➤ Start the add-on from Google Sheet ->Add-ons->WhatsApp Messages->Start ➤ Make sure the first row in your sheet contains column names. Such as ‘Fullname’, ‘Address’, ‘Phone’, ‘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 message. ➤ From the Sidebar Select the Sheet tab you want to merge data from. ➤ Select the ‘WhatsApp Number Column’. This will be the column in your sheet which contains a list of telephone numbers. Typically this is a column name called ‘Phone’. All values in this column must have a valid phone number. If the phone number does not have a country code (such as +1) the default country code will be used. To set the Default Country code go to Add-ons->WhatsApp Messages->Default Country Code ➤ Write the content of your message in the box provided and insert Personalized Fields wherever you want in the message. For example: Dear *|Fullname|*, ➤ When ready click ‘Send Test’ to send a message to any number you want. 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 message looks you can go ahead with a full merge. ➤ A column called ‘Message 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 ‘Message Status’ column. If there is text in all the data rows for the ‘‘Message Status’ column you will get an error when you attempt to merge telling you that there are no rows to merge. ➤ Messages are sent through a 3rd party provider called waboxapp.com. You need to create an account with them and register your WhatsApp phone number with them. ADD-ON HIGHLIGHTS ★ Send messages from your own phone number. This way you can get replies directly to you. ★ It does not use a generic phone number to send emails. ★ Personalize WhatsApp messages to send unique messages to your contacts or contact group. ★ Send a test message to get a good idea on how your text message will look like. ★ Opt to merge only selected/filtered rows of data. ★ Operate online over the web without hassle. ★ No limit to how many messages you can send. ★ No limit to how many merge fields you can enter. ★ Track which rows have been merged. ★ Messages can be sent to all platforms: Apple iOS (iPhone) and Google Android (Samsung, LG, Pixel, OnePlus, Huawei, Xiaomi, Realme, LG, etc) QUESTIONS? NEED HELP AND SUPPORT? CONTACT US https://www.quicklution.com/#contact 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. PRICING / COST The add-on created by Quicklution is Free. However it uses a third-party service by www.waboxapp.com to send messages. Waboxapp allows you to send 100 free messages per month. For more on their pricing check: https://www.waboxapp.com/pricing IMPORTANT NOTE ON PRICING Quicklution is not affiliated in any way with WaboxApp. In fact we are planning to move away from using them as a Third Party service to send messages. Please contact them for connectivity and cost related issues. 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! PRIVACY POLICY 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. 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://pwm.quicklution.com/home/privacypolicy OTHER INFORMATION 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