Hi, I am having an issue with a letter mail merge where it seams to be skipping every other record then randomly do 3 in a row then skip every other for a bit then do another 3 in a row. I am using an NEXT IF merge so if the customer account number is the same it will merge all records for that customer in a table then move onto the next letter.



I am using SET LID's to create this which i have cobbled together using youtube videos and some other tips and tricks from these forums.

{SET LID1{MERGEFIELD Customer_Account}}

then the table has the following

{NEXTIF{MERGEFIELD Customer_Account}={LID1}}{SET LID2{MERGEFIELD Customer_Account}}{IF LID1 = LID2{MERGEFIELD Contract_Number}

the last row used to have the NEXTIF part but i removed it as I thought that might be creating the issue but having removed it, it was still happening

it then uses a macro to delete empty table rows which i found in these forums so thanks for that the merge works great appart from the skipping of records. I am at the end of my teather trying to figure out how to solve this problem.

Out of a total of 76 individual account numbers only 56 get merged.

Any help would be appreciated.

Attached Files

10 line merge.dotm (30.4 KB, 0 views)

See the Microsoft Word Catalogue/Directory Mailmerge Tutorial 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...-tutorial.html.

The simplest solution is to use the DATABASE field approach discussed there to group the data.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]