![]() Make sure the curser is in the box under the instructions, and on the right, click on the categories that you would like to choose. Then you get to choose which of the columns you would like to print on your labels. Then it will ask you to select the spreadsheet that has the information (in this case, addresses) that you would like to merge. Select Add-ons > Avery Label Merge > New Mergeįirst it will ask you to select the Avery product you are using. Now that Avery Label Merge is installed, any time you want to print labels from your online address book, you open a new Google Doc. You will only need to do this the first time you want to make mailing labels. When you click on it or hover over it, a blue box with a plus sign will appear. Then click Add-ons > Get add-ons…Īnd then select Avery Label Merge and add it to Google Docs. How to Print Mailing Labels on Google Docs Either way, it will be worth it in the end! Depending on the method you have used previously, this may be as easy as copy/paste, or as tedious as typing them all in individually. You need to import all of your addresses. You can do this by selecting View > Freeze > 1 row Next, we want to freeze row 1 so that we can always see it as we scroll down the page, but also so it won’t get moved around when we sort the list. Just add any additional categories in columns G, H, I, etc and I will show you how to use them later. You can also add additional categories that you may want to use for sorting your list. Then add these categories in row 1: Name, Card Name, Address, City, State, and Zipcode. Start a new spread sheet and title it whatever you would like. To start, you will need to login to your Google Account and then access Google Sheets. It is free, and you only have to have a gmail account. ![]() This year I was determined to find a solution that worked because I will need those addresses again in May when I mail out graduation announcements for my son.Īfter doing a lot of research online and only finding sites that let you use their free online address book if you bought your stamps through them or printed your labels through their site, I found the perfect solution. ![]() With this easy to follow tutorial, you can create your own free online address book to use year after year for your Christmas cards, invitations, and announcements.Įvery year, around this time, I struggle to get all of my addresses updated to print mailing labels for my Christmas cards.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |