Guide: Using Mail Merge In Google Docs: Guide

I remember one day, I was in the back of the room, and my teacher was talking about how to do a merge. I was so excited to learn this! But then she started talking about how to do it the right way, and I just couldn’t take it anymore. I wanted to leave the class.

I tried in school, in college, and in the little time I spent in an accounting firm. It never worked the way I wanted it to. More importantly, I never “got it”. I now have a tremendous amount of respect for people who interact with the Office suite day in and day out, because believe me, it’s not easy. ..

I hate how MS Office’s implementation of mail merge makes it difficult to send personal messages, but I understand its appeal. It’s better than just sending a mass email with no personal greetings, and for some people, it might be worth it to use mail merge in your workflow. There are better ways to do mail merge outside of the MS Office universe.

Alternative to email newsletters: MailChimp. It’s one of the best and easiest email newsletter services out there, and it comes with an add-on that makes it really easy to create and send newsletters. ..

Step 1: Create a spreadsheet with recipient information

Before we start, go to Google.com/Sheets and create a new spreadsheet. Enter the details for your recipients in rows with the appropriate labels. Start with first name, last name and email. You can enter fields such as Address or anything else related to your work.

Once that’s done, close the tab and we’ll get to work with the email.

Step 2: Install Merge By MailChimp Add-on

If you want to merge your Google Docs and MailChimp documents, you can download the Merge by MailChimp add-on and wait a few seconds for it to install.

Step 3: Create the email text

Google Docs is a great tool for creating beautiful page layouts. You can insert charts, images and other multimedia easily.

Step 4: Merge The Mail

Once the email body is ready, go to Add-ons -> Merge by MailChimp -> Send Email. This activates a pop-up explaining the steps you need to take before you can send the email.

Now select the spreadsheet we created in step 1 from the chooser. ..

You will see a doll in the sidebar that has been analyzed and processed with your spreadsheet data.

It already knows what the header rows, the headlines, and more importantly, which row contains the emailYou are of course free to change the details if you wish.

Step 5: Customize a mail merge

Since this is a “mail merge” and not just a mass mail, you can do things like add the recipient’s first names at the top or anywhere in the document.

To do this, click on the Merge tags button from the sidebar. This generates a tag for each row.

Now, select the first name in the document and click on the tag button.

Step 6: Add and send sender info

In the Email Info tab, enter the sender’s name, sender’s email address, email subject line, and company name and address in the footer.

Your personalized mass email is on its way.

Now that you’ve sent the email, you can track its progress and see how many of them have been opened from the Reports option in the Add-ons section. With this add-on, you can send up to 6000 emails per month. Since you’re using the services of an established newsletter company, this will also happen feature an “Unsubscribe” link and a MailChimp logo at the bottom. ..

Using Mail Merge In Google Docs: Guide: benefits

Faq

Final note

This guide will show you how to use mail merge in Google Docs to create a document with multiple sections and subsections. This is a great way to organize your thoughts and keep your documents easy to read. ..

If you have any queries about using Google Docs with Mail Merge, then please ask us through the comment section below or directly contact us. This guide or tutorial is just for educational purposes. If you want to correct any misinformation about the guide, then please contact us.