Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Houston, Texas, USA
    Posts
    100
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge - Records Dropped (XP)

    Our accounting department is running a report using an Excel worksheet as the datasource and merging to a Word document. The Word document contains a field pattern which has been copied and repeated to fill an entire page so that all records are generating continuously throughout multiple pages. The merge/Word fields are as follows:

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Mail Merge - Records Dropped (XP)

    "Next Record" sometimes is implicit, and other times needs to be explicit. So where it is implicit, adding an explicit one goes forward two records in your data source instead of one. Now... to actually figure out which one is the problem. Good luck!

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Houston, Texas, USA
    Posts
    100
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge - Records Dropped (XP)

    Wow! I can't believe it was that simple. I deleted the last NextRecord field only and that fixed the problem. Many thanks!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •