Share via

How do I get MS Word to print all my address labels, not just a few?

Anonymous
2023-12-07T22:31:52+00:00

I want to print address labels in MSWord, from Excel. There are 23 entries, and are formatted as they should be, but when I print the labels, only 7 actually print. I've had this problem for years, but in the past it printed at least most of a sheet. This year, only 7.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-08T02:42:27+00:00

    Hi

    I'm Diane and I'm happy to help you today.

    Are you doing a mail merge? When you preview the merge before printing, do you see all of the labels?

    Do you have the merge fields in all of the cells of the label template?

    This is Microsoft's article on mail merge labels. https://support.microsoft.com/office/print-labels-for-your-mailing-list-276a2cd1-74d2-43d0-ab5a-b90460358ad5

    Let me know how it goes, I'm here to help you further if needed.

    -- Diane

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-12-08T15:15:42+00:00

    Diane,

    I have seen the article and attempted to follow it.  I did a mail merge, then used an existing list for Select Recipients.  Then I   inserted each field separately for Insert Merge Fields.  After that I updated the labels. 

The format was correct, but when I previewed the results, there were only 7 entries and that's what printed.  I moved the data around so I could print at least the next entries on the  next 2 rows of vacant labels.  It would be more time consuming, but I thought I could print the labels 6-9 at a time in the spaces that were available.  I did that successfully once, but after that, when I previewed, all the spaces were blank.  I tried again today, and same result.

I've had a similar problem for a number of years and have been able to overcome it by breaking the data up into separate documents, i.e. addresses 1-15 as a document and addresses 16-30 as another and that was OK.  I also tried making separate tabs for the data, but only tab 1 would print.  Which is why I made separate documents.  This year has been the most "challenging," though I'm printing less entries than in years past.  But it's still very confounding.
    0 comments