Holiday card

The holidays are here again, and many of us dread the whole holiday card process. We love sending heartfelt notes to our family and friends, but who wants to hand-address tons of envelopes?

Have you considered printing labels for those envelopes? I promise it’s not as hard as it sounds.

The best way to do this is to create a spreadsheet with the addresses and then do what’s called a “mail merge” to move those names and addresses into labels.

YES you can do this!

Step 1 – Create your spreadsheet

Put all the names and addresses into a spreadsheet. The most important thing here is to keep each piece of information in a separate column. For example: Column A = First Name, Column B = Last Name, Column C = Address 1, Column D = Address 2, Column E = City, Column F = State, Column G = Zipcode

Step 2 – Mail Merge into a document

Close the spreadsheet (it must be closed for this to work), and do a mail merge into your word document. I highly recommend using the mail merge wizard. For those using Microsoft Word, the instructions are available here: Use Mail Merge