A weblog by Will Fitzgerald

Christmas addresses

Every year I attempt to update our address list, especially in order to send out Christmas cards. The original database of addresses I created is gone; I can’t remember what I originally used. Last year was too choatic to do anything. This year I decided to create the list from scratch. In fact, I decided I would just write out addresses in an address book.

In the end, though, I had a brainstorm. I used Google’s phone book search to look up names and phone numbers. (For example phonebook: william fitzgerald kalamazoo). I estimate that about 75% of the time, this got me to a correct address and phone number. Since I’m notoriously bad at transcription errors, this helped ensure I got the addresses and phone numbers right. Of course, Google’s address database isn’t perfect, but it was pretty good.

I then cut and pasted the address into an Emacs buffer, eventually deleting the extraneous links to maps. More search-and-replace allowed me to put in tab field delimiters, and I then slurped the data into Excel, where I cleaned things up a bit. Creating a merge document in Word was then relatively simple.

When personal computers were first coming out, and people asked what they were good for, one of the standard answers was ‘keeping an address book.’ You’d think it would be obvious how to do this, and dead simple as well. Who knew that PCs would be really for video games, email, and blogging?


2 responses to “Christmas addresses

  1. Elizabeth Calderon December 6, 2005 at 11:52 am

    Does anyone know a simple way to keep a Christmas address list and print it out on labels each year? I have a Windows XP computer with Microsoft Outlook, but I cannot figure out how to print out addresses on labels from the Outlook program. I am also willing to buy a good address software program. Any assistance would be gratefully accepted!

  2. Will December 6, 2005 at 12:02 pm

    As I wrote in my posting, the tools I eventually used as Microsoft Excel and Microsoft Word. I used the ‘mail merge’ feature of Word to print out labels.

    I don’t use Outlook, but you might be able to do a ‘mail merge’ from Outlook to Word. Here’s an article that discusses this:


%d bloggers like this: