|
I hope everyone had a wonderful Thanksgiving weekend. Now that it is behind us, no doubt you are looking ahead to the next holiday season and thinking about sending out your holiday cards.
Mail merge in Office 2010 is a great way to create labels from an Excel database. Although the initial set up can be tricky, the end result is worth the effort. Here are some simple steps to complete the process. For Office 2007, the steps are in a slightly different order. If you need assistance, please call us.
First, if you don't have an Excel spreadsheet with names and contact information, you should create one. My first row headings include First Name, Last Name, Address, City, State and Zip.
Save and close your Excel file.
From there, open Word.
From the Mailings Tab on the ribbon, select Start Mail Merge, then Step by Step Mail Merge Wizard. The Wizard pane will open at the right of your screen.
Step 1: If Change document layout is not selected, select it.
Step 2: Choose your label.
Step 3: Select Recipients.
Browse for your Excel spreadsheet containing your contact information. This will ask a few questions. Generally all of your contacts are on the first tab, but if they are located on a different tab in your spreadsheet, select the tab where the data you want is contained.
You have an option here to add or remove any recipients from the mailing.
Step 4: Arrange Your Labels.
Select Address Block, and then the Update all labels button.
Step 5: Preview your labels. The screen should look like something like this:
If you have a sheet of labels, then proceed to Step 6 to Complete the merge.
Step 6: Edit individual labels here and print. | 
