Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
It's easy to create a sheet of mailing labels from any of your tables. Click one time on Customers, go to the Create Ribbon, and then over here to Labels. It even has its own button. You can select the manufacturer of the box of labels that you have. I'm going to use Avery, and then from the list of Avery, I'm going to choose 5160, which is a standard label that you can find in any Office Supply Store. Click Next. Here, you can change the Font that you want. We're going to leave that on Arial.
You can change your Font Size. Let's go ahead and make this 9. You can change your Font Weight, anything from Thin to Heavy. We're going to make ours Normal. You can change your Text Color to any color that you'd like, but because we're on an black and white printer, we're going to stick to Black, and click OK. If you wanted you could also select Italics and Underline, but we are going to leave those off. Click Next. Now we're going to arrange our label. You have to put in all the commas, punctuation and spacing yourself.
There's two ways to move the fields over: I can click on Company and press this arrow, tap Enter on your Keyboard to go to the next line; I can also double-click on a field to move it over. Go ahead and hit Enter again after Address1 and move over Address2. Hit Enter again to go to the last line. Move City over, and type a comma and a space. Move over State, type another space yourself, and move over ZIP Code. You could move over Country as well. For the sake of this demonstration, I'm not going to.
Click Next. Now it wants to know how you want to Sort your labels. If you're going to be sending them by bulk mail, do choose Zip Code and move that over. Then choose Next. We're going to change the name of our report to Customer Labels, and let's click Finish. I didn't get an error message, but let's take a look and see if everything fits okay. Click OK. My labels actually looked pretty good.
The Mailing Label Wizard is a welcome shortcut to laying out Mailing Labels with ease.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98459 Viewers
80 Video lessons · 141507 Viewers
59 Video lessons · 59848 Viewers
52 Video lessons · 73042 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.