Share via

Problems creating labels from Excel

Anonymous
2019-12-02T14:01:54+00:00

After about an hour, I've managed to create a single page of labels in Word of 21 labels. The problem is that there are 129 labels to print. Does anyone know how to print the whole lot? or would I be quicker hand writing all my christmas card envelopes....

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
    2019-12-02T14:12:35+00:00

    Hi Innes,

    It definitely should use all of the addresses. Are you completing the merge or printing from the screen? When you complete the merge, you have an option to merge to printer or to a new document - choose new document. This is usually better so you can check the output before printing.

    Basic Steps: https://support.office.com/article/Mail-merge-u...

    Specific to labels: https://support.office.com/article/print-labels...

    Was this answer helpful?

    0 comments
  2. Jay Freedman 207.7K Reputation points Volunteer Moderator
    2019-12-02T14:09:54+00:00

    Are you using the mail merge feature in Word? If so, be sure to turn off the Preview button before you click on the Finish & Merge button.

    Was this answer helpful?

    0 comments