How to do a Mail Merge Using Google Docs

**UPDATED VERSION OF THIS POST available here. In the new version, learn how to use the newer autoCrat interface to create mail merge letters in Google Docs.**

In this How To video, we show you how to install Autocrat Script and use it to do a mail merge in Google Docs

VIDEO HIGHLIGHTS

01:05 Install Autocrat

01:43 How to set up Autocrat for the first time

01:55 How to select your template

02:18 How to select your source data

02:49 How to choose the data to fill in your mail merge fields

03:09 Where your mail merge documents will be saved

03:40 How to automatically name all your documents

04:22 Determine your format (Google Doc or PDF)

04:34 How to automatically email your document

05:05 How to determine the editing rights of the document

05:23 Automatically process the form for new submissions

06:09 The mail merge document

06:58 How to have your questions answered

07:09 Check out http://www.googleappsforedu.com

TRANSCRIPT

Hi I’m Mike Reading from the Using Technology Better Community and the blog over at usingtechnologybetter.com. In today’s short video, I’m going to show you how we can use a script inside Google Docs to easily create Mail Merge documents.

So you will notice here in my Google Drive folder that I’ve already created a few documents and I’m going to assume that you know how to create this. If you don’t, then I’ll put some links to some videos that will show you the process beneath this video.

I’ve just created a simple spreadsheet that has first name, last name and their elective choice next to it and I’ve created a Mail Merge doc that just uses the double brackets here as a Mail Merge field identifier. So you can see that there is a Mail Merge field here and there is another Mail Merge field just here.

Now to make this work, what we need to do is we need to go back to our spreadsheet and we need to install a script. So we are going to go down here to insert and then script and the script name that we are looking for is called Autocrat. So let’s just type that in there and we’ll see it just here.

So we are going to click install. Now just like every other time when you install a script for the first time, that script will just ask for you permission to be able to access your documents so you need to just give the authorisation for that and as soon as we’ve clicked on accept, what will happen is that the script will now sit on or toolbar just at the top here. So here is how we run our document.

Firstly, we click on the Autocrat script and we click run initial configuration.

So the first thing that we need to do is we need to choose where we are getting our template, what’s our merge document. Now if I click on choose template, you will notice that this is the document Mail Merge demo is the same documents as the one I just showed you that I’d already created so I’m just going to select that one and then that will file it for us.

Now we’ll just click save setting and then what will happen is the script will then go and find the source style. Now at the moment I’ve only got one sheet inside my document down the bottom here so I only have one option to choose from and this is where we now start to merge our document. Don’t worry too much about this information just here, just click submit, now it’s gone back and found my merged document and knows that it needs to find information for the first name and information from the elective.

Now these words don’t have to relate back to anything inside your spreadsheet because what I can do is just choose the column that I would like.

So first name, I’m obviously going to choose first name and elective, I’m going to choose the elective choice so now it knows where to pull that information from. So we just click there save settings and now what will happen is that script will start to build.

So the first thing we need to do now is just say where we want our document to be saved. Don’t forget too much about all these information up here, we just need to click this box here and say where we would like to save it. Now if I jump back over to my drive folder for a second, you will see that I’ve created a folder inside my Mail Merge doc folder that is where my documents will be saved. So I’m simply going to come over here, choose that Mail Merge docs folder just there and then we need to say how we’d like to name our document. Obviously when you create a document, it creates one copy for every person who is going to receive a response and so you might like to name that document, so it might be Mike’s Elective Choice for instance. So to do that, we come up here to our list of option and we click on first name and just highlight that and drop it in here and so first name… and I can go elective choice. Now if you had more than one person with the name Mike, you might go first name and then go up and grab the last name so it would be first name, last name elective choice.

The next thing that we get to decide is what format we want that document to be created in. Do we want to keep it in a Google Doc or do we want to create at PDF. Now once you’ve decided what type of doc that you would like, then what you could do is email or share that document with the person that you are merging the document for. Now you could put the recipient email address in here. I don’t have that option because in my spreadsheet over here, I didn’t ask for their email address but if you had, that would come up here as an option for you and this would automatically find those email addresses and send each person a copy. No the great thing about this is if you come down here to attachment type, you can then determine is this doc that you are going to share with them, something they can just be viewed or whether or not they can edit. So you are able to individually share documents with others and then automatically determine what their rights are going to be in terms of that doc.

The last thing that we have here is a box where we can trigger merge on form submit. If your spreadsheet was linked back to a Google Form then what could happen is that Autocrat could run automatically in the background that every time somebody fills out the form, it will automatically process that form, merge the document, email the document to them so it’s not something that you have to do manually which is a fantastic time saver.

So at the moment I’m just going to un-tick that and then I’m going to click save settings and now what we can do is we can say do we want to just test it on the first row so you might have put your data in there to start off with, to test it. You can run the whole thing or you could just set it up and just say don’t run just yet.

I’m just going to run the merge. Now if I go back to my drive folder and click on merge docs, you will see that I have the three documents that I’ve created, they’ve all been automatically named for me and if I open up one of the documents, you will see that the fields are out for me just here.

So it’s says “Hi Pete” there was the first name. “This is a quick reminder that your minecraft elective starts at 3:30.” If we go back to our sheet you will see that Peter has a minecraft elective and there it is there.

So hopefully you can see how you’d be able to use this to save yourself a lot of time when merging documents. The automatic trigger feature is fantastic. There are some features for you to create a document link inside here as well so that you can just link to those documents really quickly.

If you have any questions, I love you to drop a question or a comment in the comment section below and we can continue the discussion from there.

Related Post

How well do you use the
Apple Apps Google Workspace Microsoft 365
tools in your workplace?

Find out if you’re working with the tools OR if you’ve got the
tools working for you.

What Industry Are You In?

Using Apple Apps, Google Workspace or Microsoft 365?

What Type of user are you?

🫣 Entry User | 🤹 Skilled User | 👑 Elite User

Take the quiz to find out. 

Privacy Policy

Using Technology Better Privacy Commitment

Introduction

We hold the privacy of your personal information in the highest regard.

Using Technology Better regards customer privacy as an important part of our relationship with our customers. The following privacy policy applies to all Using Technology Better users, and conforms to Internet privacy standards.

This policy will be continuously assessed against new technologies, business practices and our customers’ needs.

If you have questions or concerns regarding this statement, you should first contact the support team on our Contact Us Page.

Collection of Information

In order to use the Using Technology Better website, we may require information from you in order to provide the best service possible.

All correspondence may also be collected and stored, particularly in regard to sales, support and accounts, including Email.

Any information collected by Using Technology Better is collected via correspondence from you or your company. This may be via the telephone, Email, mail, fax or directly through our website.

Visitors and customers of japan.usingtechnologybetter.com will have their information shared back to DAIWABO INFORMATION SYSTEM CO., LTD. and DIS Service & Solution Co., Ltd.

Use of Collection Information

Any details collected from Using Technology Better customers is required in order to provide you with our

products and/or services, and a high level of customer service.

Correspondence is recorded in order to provide service references, and to assist in our staff development.

Web Site Use Information

Similar to other commercial Web sites, our Web sites utilize a standard technology called “cookies” (see explanation below, “What Are Cookies?”) and web server log files to collect information about how our Web site is used.

Information gathered through cookies and Web server logs may include the date and time of visits, the pages viewed, time spent at our Web site, and the Web sites visited just before and just after our Web site.

Storage of Collected Information

The security of your personal information is important to us. When you enter sensitive information (such as credit card numbers) on our website, we encrypt that information using secure socket layer technology (SSL).

When Credit Card details are collected, we simply pass them on in order to be processed as required. We never permanently store complete Credit Card details.

We follow generally accepted industry standards to protect the personal information submitted to us, both during transmission and once we receive it.

If you have any questions about security on our Website, you can email us at <ContactEmail>.

Access to Collected Information

If your personally identifiable information changes, or if you no longer desire our service, you may correct, update, delete or deactivate it by emailing us at <ContactEmail>.

Orders

If you purchase a product or service from us, we may request certain personally identifiable information from you.

You may be required to provide contact information such as:

Name

Email

Postal address

Your school or organisation

Financial information (such as credit card number, expiration date, name on card, card billing address).

We use this information for billing purposes and to fill your orders. If we have trouble processing an order, we will use this information to contact you.

Communications

Using Technology Better uses personally identifiable information for essential communications, such as

Emails

Accounts information

Critical service details.

We may also use this information for other purposes, including some promotional Emails.

If at any time a customer wishes not to receive such correspondence, they can request to be removed from any mailing lists by contacting support.

You will be notified when your personal information is collected by any third party that is not our agent/service provider, so you can make an informed choice as to whether or not to share your information with that party.

Third Parties

Using Technology Better may at its discretion use other third parties to provide essential services on our site or for our business processes.

We may share your details as necessary for the third party to provide that service.

These third parties are prohibited from using your personally identifiable information for any other purpose.

Using Technology Better does not share any information with third parties for any unknown or unrelated uses.

What Are Cookies?

A cookie is a very small text document, which often includes an anonymous unique identifier. When you visit a Web site, that site’s computer asks your computer for permission to store this file in a part of your hard drive specifically designated for cookies.

Each Web site can send its own cookie to your browser if your browser’s preferences allow it, but (to protect your privacy) your browser only permits a Web site to access the cookies it has already sent to you, not the cookies sent to you by other sites.

Browsers are usually set to accept cookies. However, if you would prefer not to receive cookies, you may alter the configuration of your browser to refuse cookies.

If you choose to have your browser refuse cookies, it is possible that some areas of our site will not function as effectively when viewed by the users.

A cookie cannot retrieve any other data from your hard drive or pass on computer viruses.

How Do We Use Information We Collect from Cookies?

As you visit and browse our Web site, the site uses cookies to differentiate you from other users. In some cases, we also use cookies to prevent you from having to log in more than is necessary for security.

Cookies, in conjunction with our Web server’s log files, allow us to calculate the aggregate number of people visiting our Web site and which parts of the site are most popular. This helps us gather feedback to constantly improve our Web site and better serve our clients.

Cookies do not allow us to gather any personal information about you and we do not intentionally store any personal information that your browser provided to us in your cookies.

Legal

We reserve the right to disclose your personally identifiable information as required by law and when we believe that disclosure is necessary to protect our rights and/or comply with a judicial proceeding, court order, or legal process served on our Website.

Links

Links on the Using Technology Better site to external entities are not covered within this policy. The terms and conditions set out in this privacy statement only cover the domain name of usingtechnologybetter.com

Changes to Privacy Policy

If we decide to change our privacy policy, we will post those changes to this privacy statement, and other places we deem appropriate so that you are aware of what information we collect, how we use it, and under what circumstances, if any, we disclose it.

We reserve the right to modify this privacy statement at any time, so please review it periodically. If we make material changes to this policy, we will not use the personal information you have submitted to us under this Privacy Policy in a manner that is materially inconsistent with this Privacy Policy, without your prior consent

Delivery Policy

Most goods are digitally delivered instantly via email.  Our services may be delivered either via an online medium or live in person.

For our online delivery see below.  For services delivered live onsite, please refer to our speaker agreement form which is emailed to you on confirmation of booking.

Refund Policy

We do not offer refunds or returns unless we cannot supply goods or services or the goods or services are not delivered as promised.

Australian law is the governing body for all work, goods and services supplied by Using Technology Better.

Marketing Release

Using Technology Better (UTB) may film, record, and photograph me (the results of which are the “Recordings”). UTB may also incorporate into any production(s) any separate content (e.g., quotes, testimonials, biographical information, profiles, photos, videos, sound recordings, artwork, etc.) I provide to UTB or approve in writing (“Materials”).

1.License

I grant to UTB an irrevocable, perpetual, worldwide, royalty-free license to, in its sole discretion, (i) edit, translate, and modify the Recordings and the Materials, (ii) attribute the Recordings and Materials to me by my name, age, and city and state of residence, (iii) incorporate the Recordings and the Materials into content to promote UTB, its programs, or products (“Content”), and (iv) publicly use, distribute, reproduce, create derivative works from, and perform/display the Content, and any excerpts thereof, in any language.

2. No Compensation.

I grant this permission without any financial or other obligation of any nature.

 

For any issues or concerns please contact us