It’s official, we are officially getting married. I just dropped off the Save the Dates at the post office. With a huge wink and promise of future cookies to the post master, he lovingly hand-cancelled each of my postcards. I feel like a mother bird watching all my fledglings leaving the nest. Who knew dumping a stack of paper at the post office would illicit such an emotional response?!? *Wipes eyes with lacy handkerchief*
In this digital age, I saw no reason to sit and painstakingly hand-address each and every single Save the Date postcard. Avery makes a line of mailing labels that are clear. I snagged some clear 1”x 2 5/8” Avery 18660 labels to use on the Save the Dates and the invitation envelopes.
The thing I had the hardest time with was making a mail merge template that would allow me to address the invitations in the traditional sense. The standard, Mr. and Mrs. Jimmy John, works well and fine if you have a married couple that shares the same last name on your invitations. In this day and age though, there are a lot of blended families. Not everyone shares the same last name, or they are unmarried, or any number of things. After arranging and rearranging everything a million times, I finally came up with a template that allowed me to accommodate all the flavors families come in. Both original documents are made in Word and Excel, but Google Drive has an Avery add on extension that will let you create labels in Google Docs if you don’t own Word.
I thought I would share the wealth so that if you wanted to make your own labels, you would have a bit of an easier time. You can find the Excel spreadsheet here and the Word mail merge label template here.
When you download each file, save them in a place you can easily access. You can go into the Excel file and update the information with your guest list. I left a few examples in there to give you an idea of what it should look like. Once you have your guests in the Excel document, go ahead and open up the Word template.
You will be prompted to select a data source for the SQL. Select Yes and select the Excel file where you have saved your guest list.
Go to the mailings tab in Word and there you have all your mail merge tools. There is a preview results section on the screen. Make sure this is set to label 1. If you click on this, it will pull in the information from the Excel sheet and you can see your labels live. It lets you scroll through pages of labels so you can check them for any errors.
Load up the printer with the labels, and BAM, some nice clear labels that saved you hours of time holding a pen and dealing with hand cramps. WOOT! Hope some of y’all find this helpful. Enjoy your cramp-free hands!