Today's Technology Tip is all about how to make address labels using Microsoft Excel and Word. The examples below are from the XP versions of Excel and Word. Other versions of the programs are similar enough that these examples should give you a pretty good start.
First you have to have a data base or names and addresses to work with. I would recommend that you make your address list in Excel because it's fairly easy but you could make it in Access of course. Your data base should be set-up something like this:
Save your data base (Excel Spreadsheet in this example) to your computer and open up MS Word. We'll use the Mail Merge Wizard to do this. Go to Tools, Letters and Mailings, & Mail Merge Wizard:
In the Task Pane (on the right hand side of the screen) you will now have some options to pick. Select “Labels” from the list. Then click “Next: Starting document” in the bottom right hand corner.
Click on “Label Options…” to select the type of label you’ll be using and how you’ll be printing them. In this sample I am using Avery 5160 – Address which is a pretty standard label. It has 30 labels to a page.
Then click “Next: Select Recipients” in the lower right hand corner of the screen
We want to “Use and existing list” and then “Browse…” to find it. You will have to search through your H: drive to find the Excel File you just saved.
Next you will have to tell the computer which sheet in the excel file to use. If you remember from Tech Tip Number 25 there are 3 worksheets or "Sheets" in every Excel file. In this example you want to select Sheet$1 and then click “OK”
The next window that appears is used to control what information you want to mail merge. In this example I will be using all the information. All I have to do is click “OK.”
At this point you can finish the mail merge without the Wizard (I actually find iteasier this way). When we selected our data base (the excel file) some new toolbar buttons appeared.
Use the “Insert Merged Field” button to start putting fields on your mailing labels:
When you are done inserting merge fields click “Close” You might have to re-arrange the address so it is in the correct order:
We’re almost done! Now we have to merge the data onto the labels. Click “Next: Arrange your labels” in the lower right hand corner:
Now its time to replicate the mailing label. To do that click on “Update all Labels” in the middle right hand side of the screen. Then click on “Next: Preview your labels”
Whoopie! Almost Done! It’s starting to look like a mailing label. Click “Next: Complete and Merge” in the bottom right hand corner:
ONE MORE THING:
We have had problems with mailing labels where we didn’t merge them to a new document (especially large, multi-page labels). Make sure you go to thetool bar and select “Merge to New Document” before you print or save your labels.
All that’s left to do is save the file and then print the labels. Please always remember to save your file in case something goes wrong in the printing (it saves time redoing your work).
You’re on your own to figure out how to load the paper so it prints on the right side.