Word mail merge next record not recongized

Posted on 2012-08-13
Last Modified: 2012-08-13
I have an existing mail merge document that uses an MS Access table as its data source.  It works fine.  I am attempting to convert it to use either a text file or a document file to remove the need for MS Access.  But the mail merge doesn’t work with either type of file.  The document consists of 9 fields, 4 of which are in the top of the document and 5 which repeat in the body of the document.  “Next Record” is placed at the second and subsequent rows of data.  However, when the merge takes place, only one record in placed into the document. Any ideas?
Question by:kilfoy
    LVL 76

    Accepted Solution

    Very difficult without seeing the main document (and, perhaps, the datasource). Normally, there is no need to manually enter a <<Next Record>> field. There should only one such per record.
    Are you trying to print labels or a directory merge, both of which would need more than one record per output  'page'?.

    Author Comment

    I finally figured it out.  There was a double quote in one of the fields and the application wasn't putting the entire field in quotes and doubling the internal quote.  I have no idea why I didn't see it before but I'm glad I finally got it.  THanks for taking the time to respond.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now