wondering, what is cooking in our minds today? Well, let’s create a mail merge in Google Sheets that allows you to create and print hundreds of address labels through Google Docs.
let’s discover the magic of this plugin.
Note: Before proceeding to the first step, make sure you’re signed in to your google account. remember, we’ll also need google docs to install a plugin there to do our job.
opens google documents. click “add-ons” in the menu bar and then “get add-ons“.
once you click on “get plugins“, a small popup will appear. type “avery” in the search bar and press enter.
You will see a plugin called “avery label merge“, click the “+ free” button to install it to your google documents.
after clicking the “free” button, another small popup will appear asking you to choose an account, select the desired account there.
After selecting your account, a new page will appear requesting permission to access your account. click allow to complete the installation process.
to verify the installation, click plugins and you will see all the tags are merged there.
now open the google sheet that has all the names and addresses saved.
For this tutorial, we’ve created a new sheet called “addresses” with some names and addresses. don’t forget to label the column headers in the first row.
now open a new google document > plugins > avery tag combination > new combination
now, a small popup will appear, select “address tags“.
here, you need to select the sheet pattern according to your requirements. we will select “10 labels per sheet”.
In this step, select the spreadsheet where all the addresses are saved and you need to merge them.
we will select the spreadsheet called “addresses”.
in the left sidebar, click first name, lastname and address. all three terms should appear in the box labeled “label or name tag“.
Now, click “merge” at the bottom of the sidebar to start the merging process.
a pop-up will appear with a confirmation message of the created document. click open to see the final sheet.
a new google doc will open with the address labels that are ready to print.
you need to do all this using google chrome.
In this post, we have described how to print address labels using Google Sheets Mail Merge. .
Not only this, mail merge can be used for many other jobs. we will cover them one by one. stay tuned!
- quick mail merge plugin: send emails directly from your google sheet