Click here to Skip to main content
15,881,204 members
Articles / General Programming / Printing
Tip/Trick

Printing Labels in Word

Rate me:
Please Sign up or sign in to vote.
5.00/5 (5 votes)
15 Dec 2022CPOL2 min read 11.1K   10   10
How to print labels in Word
Every time I have to print bulk labels - about once a year - I have to find the right instructions and then get confused and swear a lot. I also swear a lot when I want to print a single label on a used sheet. So I assembled this to show me what to do next time.

Introduction

Every Christmas, I have to do the Christmas cards, so I circulate a list of victims recipients so they can be posted in plenty of time and no-one gets forgotten and sulks. This goes on a spreadsheet, which is used as the basis for next year's card list.

But every year, it's the same, I can't remember how the heck you persuade Word to print the damn things, and end up getting confused and swearing a lot. So I typed it up this year, and added the "print a single label" bit as well, because I do that most times I have to use snail mail.

Then I thought I'd share it, because with a guide, it's pretty easy to do.

Printing a Single Label on a Used Sheet.

Type your letter in Word as normal, and highlight the "To" address:

Image 1

Select the “Mailings” ribbon and click “Labels” from the “Create” group.

Image 2

Under “Print”, select “Single label”, and pick the row and column you want (1s-based).

Image 3

Click the “Print” button.

Bulk Labels from Excel Sheet

Select the “Mailings” ribbon, and from the “Start Mail Merge” group, open the “Start Mail Merge” drop-down.

Select the “Step-by-Step Mail Merge Wizard…

Image 4

Select “Labels” on the right, and press “Next: Starting document” at the bottom right.

Image 5

Select “Label options” and pick your label type.

Image 6

Image 7

Click “Next: Select recipients”.

Image 8

Click “Use an Existing list”. Click “Browse” to locate the spreadsheet. “Ole DB Database files” is fine and select the right sheet.

Image 9

Image 10

Image 11

Image 12

Click “Next: Arrange your labels”, then click “Address block”.

Image 13

Image 14

Highlight it and change the font, line spacing, etc. as necessary. Press the “Update all labels” button.

Image 15

Image 16

Image 17

Click “Next: Preview your label” If you are happy, click “Next: Complete the merge”.

Image 18

Image 19

Click “Print…” and set your paper type (thick is good), then just print as normal.

Image 20

History

  • 15th December, 2022: Original version

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
CEO
Wales Wales
Born at an early age, he grew older. At the same time, his hair grew longer, and was tied up behind his head.
Has problems spelling the word "the".
Invented the portable cat-flap.
Currently, has not died yet. Or has he?

Comments and Discussions

 
QuestionThanx for compiling and writing the article on printing labels Pin
jmaida16-Dec-22 7:49
jmaida16-Dec-22 7:49 
AnswerRe: Thanx for compiling and writing the article on printing labels Pin
OriginalGriff16-Dec-22 20:13
mveOriginalGriff16-Dec-22 20:13 
QuestionPrinting labels. why does this have to be so hard. Pin
jmaida16-Dec-22 7:45
jmaida16-Dec-22 7:45 
QuestionSeriously? Pin
haughtonomous16-Dec-22 3:01
haughtonomous16-Dec-22 3:01 
AnswerRe: Seriously? Pin
OriginalGriff16-Dec-22 4:12
mveOriginalGriff16-Dec-22 4:12 
GeneralRe: Seriously? Pin
haughtonomous16-Dec-22 11:51
haughtonomous16-Dec-22 11:51 
GeneralRe: Seriously? Pin
OriginalGriff16-Dec-22 20:20
mveOriginalGriff16-Dec-22 20:20 
QuestionAfter ... Pin
Richard MacCutchan15-Dec-22 4:33
mveRichard MacCutchan15-Dec-22 4:33 
AnswerRe: After ... Pin
OriginalGriff15-Dec-22 5:08
mveOriginalGriff15-Dec-22 5:08 
GeneralRe: After ... Pin
Richard MacCutchan15-Dec-22 5:16
mveRichard MacCutchan15-Dec-22 5:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.