


So here is how we run our document.įirstly, we click on the Autocrat script and we click run initial configuration. 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 let’s just type that in there and we’ll see it just here. 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. 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 you can see that there is a Mail Merge field here and there is another Mail Merge field just here. 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. If you don’t, then I’ll put some links to some videos that will show you the process beneath this video. 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. 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. Hi I’m Mike Reading from the Using Technology Better Community and the blog over at.

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Ġ1:43 How to set up Autocrat for the first timeĠ2:49 How to choose the data to fill in your mail merge fieldsĠ3:09 Where your mail merge documents will be savedĠ3:40 How to automatically name all your documentsĠ4:22 Determine your format (Google Doc or PDF)Ġ4:34 How to automatically email your documentĠ5:05 How to determine the editing rights of the documentĠ5:23 Automatically process the form for new submissionsĠ6:58 How to have your questions answered **UPDATED VERSION OF THIS POST available here.
