15 hours of free training in just 5 minutes a day
Some Shortcut Keys
How Many Words Per Minute
Flip Your Screen
Search Like a Pro
Technology Tip Number 27
Just Mail Merge It
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 it easier 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:
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
PRACTICE ACTIVITY: If you don’t have to do a mail merge today save this email someplace where you can find it the next time you have to.
TO KEEP ON LEARNING: If you'd like to learn more about mail merging try searching the internet for:
Have a Nice Day!
|© 2006 180TechTips.com|