• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • Last Modified:

Word 2010 - Mail Merge Labels Not Being generated properly

I'm trying to create labels and only the first label (top left) is being printed on the page. Then it goes to the next page.
I inserted the merge codes.  (See graphic).

mail-merge.png
0
brothertruffle880
Asked:
brothertruffle880
  • 2
1 Solution
 
Jackie ManCommented:
You need to copy all other field codes, i.e. Address, zip code, state... etc to all labels on the page.
0
 
Jackie ManCommented:
Please see the attached for a sample label file (in .docx format) and data file (in .xlsx format).
Label.docx
Data-for-Label.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello brothertruffle,

there is a command on the Mailings label called "Update all labels" in the "Write & Insert Fields" group.

You set up your fields in the first label, then click that command and all the other labels will populate automatically.

The same goes for changes: Make changes only on the first label, then click "Update all labels" and the changes will be reflected in all other cells of the table (after all, a label layout in a Label Merge is just a table).

Does that work for you? If not, please post a sample file that shows the problem.

cheers, teylyn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now