In this step, select the spreadsheet where all the addresses are saved and you need to mail merge them. Here, you have to select the sheet pattern as per your requirements. Now, a small popup will appear, select “ Address Labels”. Now open a new Google document > Add-ons > Avery Label Merge > New Merge Don’t forget to label the column headers in the first row. Now open the Google Sheet that has all the names and addresses saved.įor this tutorial, we have created a new sheet named “ Addresses” with some names and addresses. To verify the installation, click on Add-ons and you will see Avery Label Merge there. Click Allow to complete the installation process. You will see an add-on named “ Avery Label Merge”, click on the “+ Free” button to install it into your Google Docs.Īfter you click on the “ Free” button, another small popup will appear asking to choose an account, select your desired account there.Īfter selecting your account, a new page will appear asking permission to access your account. Write “ Avery” in the search bar and press enter. Once you click on “ Get Add-ons”, a small popup will appear. Click on “ Add-ons” in the menu bar and then “ Get add-ons”. Remember, we’ll also need Google Docs to install an add-on into there to get our work done. Note:Before proceeding to the first step, make sure you are logged on your Google account. Wondering, what’s cooking today in our mind? Well, we are going to create a mail merge into a Google Sheet that enables you to create and print hundreds of address labels through Google Docs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |