The complete and easy guide – how to use mail merge gmail in 2020?

To prepare your email draft you can type an email content as you are typing a normal email. Follow these steps:

1. Click on compose button.
2. Type subject for the email.
3. Write the body text of the email. Where ever you want to add the field from mail merge write the same field which you have written in google sheet column header. Add the header by inside double angular brackets, for example, <<Name>>.
   

   

2. Open Google sheet

Open google sheets and click on + symbol to select blank google sheet.

Now type name and email in the first two columns. Type the required data. You can use existing data from worksheet also.

1. Click on Add On ￫ Get add-ons the menu in google sheet menu bar. Observe the following screenshot.

   

2. Wait for a moment and until a new screen appears with a list of add ons. Scroll down until you will YetAnotherMailMerge. Click on YetAnotherMailMerge.

   

3. Now it will ask to install this add on. Click on Install. A get ready to install option screen will appear. Click on the continue button.
4. Wait for a while until the process finished.

Click on add ons ⟶ Yet Another Mail Merge ⟶ Start Mail Merge option. Wait for few seconds, google sheet will prepare it for the mail merge.

Now it will ask you to purchase the add on for more functionality. The basic free version of add on provides you 50 emails/day. If you want to purchase then select your desired plan or use the free version. Click on continue button for using it free.

I hope you like this post. I would like to suggest you send an email right now itself using this trick and comment on what you experienced.