If you are doing any business you have to send email to lots of peoples with different content. You can do that in once by Mail merge. Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. So lets get started how to do it.

Step 1 Login to Gmail and go to Google drive.

Step 2 Go to New and select Google sheet.

Step 3 Go to Add-ons and then Get add-ons.

Step 4 Search for yetanother mail merge and click on Free.  

Step 5 Select your Email address or login with the email from which you want to send emails.

Step 6  Click on allow to proceed.

Step 7 Select Import contact option as per your convenience.

Step 8 Create a google Sheet consisting of Email address, Name, Time etc.


Step 9 Go to compose and create a email with the fields name like {{field name}}.

Step 10 Go to the Add-ons then click on start add-ons.


Step 11 Select your email draft which you want to send.

Step 12 Now you can check the Email.  

Step 13 you can also check the status of your Email (add-ons ->yet another mail merge ->open tracking Quota).


Please comment and let us know if you phase any challenges.