Mail merge from Excel to Word 2013 not working

Posted on 2014-07-14
2 Ratings
Last Modified: 2016-02-08
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:

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??
Question by:M_Epstein
    LVL 76

    Assisted Solution

    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
    LVL 69

    Accepted Solution

    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.

    Author Closing Comment

    Thank you both very much for your expert guidance.
    LVL 69

    Expert Comment

    Thank you Mark a pleasure to help you where I can. :)

    Expert Comment

    I have 267 records but can only see or print one page of labels. What am I doing wrong?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now