Updating Christmas Address bookOne of the necessary but painful activities of the holiday season is the annual updating of the address book. Yes, it’s all part of organizing for Christmas and must be done before sending out Christmas cards, but it’s a job best swallowed with a bottle of wine and lots of music.

A few years ago my address book was just that—a book. A little yellow book I kept in the kitchen with phone numbers and addresses. I learned early on never to take a pen to this precious book, always pencil, for easy updates. Still, some members of my family have moved so often the paper was worn through with erasing. And I could never tell from one year to the next whether the address I had was the current one. As new addresses came to me, usually via the previous year’s holiday cards, I’d toss them in a pile for updating next year, sometime around December 15th.

Since then, I have upgraded my system to an Excel spreadsheet. The advantages to this are that it’s easy to make changes, and you can keep track of the changes if you want to. You can also use the list to print envelopes or address labels in Word. It’s not as convenient as I’d like it to be, however, because I still let the changes pile up and do them all, you guessed it, around December 15th.

I took an informal poll in our office to see if anyone had a better solution. I was surprised to find that about a third of us, even some of our IT gurus, are still in paper mode. Another third use some form of electronic spreadsheet, like I do. And the rest, the early adapters, have moved to a Google Doc format. A Google Doc is free to set up, and accessible from most smart phones and from any computer. This means that you can update addresses the minute you hear about a change, and that you have access to this updated address list wherever you are. You can also share it with other members of your family, and they can make updates, too.

When it comes to organizing for Christmas it seems that I am behind the times, as usual. But since it’s just one simple step to convert my Excel list to a Google Doc, I am not that far away from a state-of-the-art address book. I love the idea of having access to it on my phone. The downside is that currently you cannot print labels or envelopes directly from Google Docs, but it’s easy to export it back into Excel or Word to do this. Besides, I haven’t decided whether I’m going to hand-write or print address labels this year. I will make that decision later, probably sometime around December 15th.

Have you started organizing for Christmas or shopping for Christmas cards?  Find other ideas on addressing Christmas cards on our blog.