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

Mail merge is a great way to send a mass email with personal greetings, but it can also be used for newsletters. It’s not the best way to do it, but there are other ways that are better. ..

I would like to tell you about an add-on that is intuitive, user-friendly, and really works. It comes from MailChimp, one of the best and easiest email newsletters services out there.

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, easy-to-read pages. 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 in the chooser.

You will see a doll in the sidebar up analyzed and processed with your spreadsheet data. This doll will be used to help you understand how your data is affecting your results. ..

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

You can also add a subject line that will help you group the emails together. For example, “New Year’s Resolutions” or “Weekly Update.” ..

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.

You can easily send a personalized mass email with Send Email. ..

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 using services from an established newsletter company. Additionally, there is an “Unsubscribe” link and MailChimp logo at the bottom of each email for those who want to unsubscribe. ..

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.