Ask a new question

Problem creating Mailing Labels in Word Mail Merge (only the first label prints)

Hi, Its holiday time and I am trying to create a set of mailing labels.  My addresses are in in Excel, (Columns are Title, First, last, Street and City/State/zip).

I created the label template in Word using the Avery Number, and added <Address> to the first label.  All subsequent labels show <Next Record>.  Preview seems to work, it displays the first label and I can step through the names one at a time.  However, when I select create and print, all I get is the first label at the top of the page.  The other 29 labels are blank.  There are no empty rows or columns in my address list,  How do I get it to print all of the labels on the page?

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

You did not state the version of Word you are using.  Recent versions of WORD has a mailMerge button titled "Update Labels", at least that's the title in 2013, don't recall about '07.  When you have label #1 layout set, use this button to apply the layout to all other labels on page.

 

Hope this helps.

 

JR

40 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I'm guessing you're using the Mail Merge Wizard? It's a little silly, but the function to populate the remaining labels is actually outside the wizard. 

Go to the "Mailings" ribbon at the top of your Word session. On that ribbon, there should be a small option called "Update Labels." Select "Update Labels." Then you can go back to your to the Wizard and finish things up. 

Before printing, double-check that it worked okay by choosing "Edit Individual Labels" > "Merge All" to preview the labels and make sure that "Update Labels" took. 

65 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Having this same problem (in Word 2013), but I can't try this because the "Update Labels" button stays grayed out at the top no matter what I do. 

9 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Is the mail merge main document a label type? Do you have a data source attached to it?

If you want to send me the files I will investigate the problem.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I'm having a similar issue.  I get to the last step finish and merge and select all to get all the addresses on my labels and then a circle appears and never stops spinning.  I have never had an issue like this before and I'm extremely frustrated.

my email address is: *** Email address is removed for privacy ***  My sons emial is attached to the microsoft account.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

If you want to send me the files with a description of the problem in the covering email message, I will investigate the issue.
Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I am also having problems trying to create labels in Word.  The "Update Labels" is grayed out.   Also When I select labels in the Wizard, when I get to the section to create the address it shows to create "letters" not labels..   

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Was this issue ever resolved for you, it's now Dec 2016 and I am having the same issue.  

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

What version of Office are you using?

See the article “Mail Merge with Word 2007/2013” on fellow MVP Graham Mayor’s website at

http://www.gmayor.com/merge_labels_with_word_2007.htm

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I am using Word 16 and Excel 16.  I am still having the same issue as stated above.  I have tried everything you suggested but when I choose to print it only prints one label per page instead of all the labels requested.  What do I do now?

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Question Info

Last updated April 24, 2024 Views 43,669 Applies to: