Mail merge from Excel to Word 2013 not working

I am trying to merge an address list from Excel 2013 (.xls, .xlsx) to Word 2013 to create AVERY 5960 address labels. I am using the following Microsoft document to do this: http://office.microsoft.com/en-us/word-help/mail-merge-for-labels-HA102809780.aspx

I follow the entire example. I see the blank label template come up in Word, the address block is formatted correctly. During preview, I see all 79 records.

When I finish the merge and try to print the labels, it only prints one address block in the upper left hand corner, and only merges the first three records.

What am I doing wrong??
M_EpsteinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
There is (in my Word 2007) an 'Update Labels' button. You haven't mentioned using it. It is necessary to do so after any edits to the first label where you insert the merge fields
0
MereteCommented:
M_Epstein going on this>I am trying to merge an address list from Excel 2013 (.xls, .xlsx) to Word 2013

This source from Microsoft Office Community found this solution.
1) create Excel file using Excel 2013 normally, and save it as ".xls"  vs  "xlsx"

2) close the file & Excel from desktop.

3) create blank word document and save it as ".doc"  vs ".docx"

4) close the file and Word from desktop

          I know this sounds funny, but works this way, and read from another persons posting

5) open Excel FIRST, but do not open any file

6) open Word, and open the blank word document from step #3

7) follow all directions for creating the labels for the mail merge in Word,  Except

    select "OLE DB Database Files" from the SELECT DATA SOURCE

8) select the second entry (named when creating Excel data file) in the MICROSOFT OFFICE Excel dialog box for NAMED or CELL Range and NOT "Compatibility Reports$"

9) don't forget to "UPDATE LABELS" as a step before Previewing or printing labels..This was also left out of their documentation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
M_EpsteinAuthor Commented:
Thank you both very much for your expert guidance.
0
MereteCommented:
Thank you Mark a pleasure to help you where I can. :)
0
jetilyCommented:
I have 267 records but can only see or print one page of labels. What am I doing wrong?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.

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.