Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9141
  • Last Modified:

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??
2
M_Epstein
Asked:
M_Epstein
2 Solutions
 
GrahamSkanCommented:
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
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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