I may be a little late on this one, as it probably would have been helpful BEFORE you started receiving those Christmas cards, but I figured I'd share it anyway because it may be helpful for next year.
This is how I organize my Christmas Card Addresses. It begins with: Creating labels for the Christmas Cards I send out: I have created my address list in Microsoft Excel. It looks a little like this:
I print this out, along with using it to create my Microsoft Word mail merge to make the address labels. These are the labels I use:
The printed labels look like this:
These are the labels I attach to my Christmas Card Envelopes {no writing out 125 + addresses for this chick}
NOW for keeping track of the addresses of family & friends: This is my way: Remember that Excel printout? Well, I fold it in half
just so it fits nicely in the front of my address book.
and as the Christmas Cards come in
I check to make sure I have the correct address,
and if not I simply write in the new address
and if I recieve a card from a friend that I don't have on my list
I write their name & address to the bottom of my list.
Sometime after Christmas, I then go back to my Microsoft Excel Spreadsheet & update the addresses, adding the new ones to it. Where they wait for next years Christmas Cards.
That is so smart. The ONE thing I can never organize are addresses for Christmas cards. Every year I wind up scrambling round to find them!
ReplyDeletelove this..im so unorganized about cards..this inspires order for me! thanks!
ReplyDeleteI save all of mine in my gmail and then handwrite them. Seems like we have more each year. Is mail merge really that easy? Or do you have to do something special in Excel?
ReplyDeleteCreating a mail merge in Word is easy.. you actually save your addresses in Excel {remembering where they are} & in Word, open a new document: go tools:letters & mailings: mail merge: labels, and follow the steps. Once you get to the step of "selecting recipients" click browse, and find your excel addresses. :)
ReplyDeleteOh yeah, and in Excel, simply set it up the way I did with Column A1 as first name, A2 as last name, etc. and actually type FIRST NAME, LAST NAME, ADDRESS, CITY, STATE, ZIP in the Line 1 row & the 2nd line row would be your first addressee. Hope this helps.
ReplyDeleteThat looks like a great system! Thanks for sharing it on my Organizing MIssion Monday link party!
ReplyDeleteI look forward to having you share weekly! (hopefully.... your blog is wonderful)
I did the same thing this year with the labels, so much easier! Now I just need to get it all put in an excel document to print..
ReplyDelete