Mail Merge with Gmail – How to use it

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.

yX Media - Monetize your website traffic with us

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.

Next

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.

Next

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).

Next

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

Advertisements

Say Something on this!!!