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.
#Free online contact book how to
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 kommentar(er)
