Mail Merge in G Suite
Mail merges are very helpful if you want to run a marketing campaign or send out invitations for an Event or any other important activity with minimal time and effort. It enhances productivity by inculcating effectiveness in a simple manner.
What is a mail merge?
Mail merge in G Suite is nothing but sending emails in bulk to a number of people at the same time.
This feature is usually employed in a word processing document which contains fixed text and variables.
Some word processors can insert content from a database, Google sheet or table into text documents.
It is really a powerful and important tool for sending emails or personalized letters in bulk to a large number of people at the same time. It is productive and it also saves you time. It imports data from another source such as a spreadsheet or google sheets and then uses that to restore placeholders throughout the message or the mail with the appropriate information for each individual that is being messaged or mailed.
Now over here we will focus on doing a mail merge using Gmail and combining it with data from Google sheets. With this solution, you can now compose an email template created as a Gmail draft with data from Google sheets. The mails which are done through mail merge are sent from your Gmail account allowing it to respond to recipient replies.
Steps to do a mail merge
The steps are :
1. First of all, we have to create a mail template of the mail for which the mail merge will be done and save it as a draft. So accordingly we have created a mail template and saved it as a draft. Create a draft message in your Gmail account using markers like {{Company name}}, which correspond to column names, to indicate text you would like to be replaced with data from the copied Google sheets.
2. Open Google Sheets. . Go to Add-on and click on Get Add ons. Then a page will pop up which will redirect you to G Suite marketplace. From the top (in the search window) search for Yet Another mail merge and click on it and install it.
3. Now in the Google sheets make columns according to your need. Over here I will make columns for company name and Email address to which the mails will get delivered. Under company name and mail address, accordingly put your data for which the mail merge will be done.
4. Now go to Add on and click on Yet Another mail merge. Then click on Start mail merge and accordingly follow the steps. Select the mail template for which the mail merge is to be done and accordingly follow the steps. Then the process will start and the mails will be delivered to the respective email ids.
After the process is complete and all the emails are sent on the left side there will be a tracking report which will say how many emails are opened and how many emails are bounced back which will give you a better understanding of the mail merge done.
