View Single Post
 
Old 05-02-2025, 08:06 AM
Tonypolony212 Tonypolony212 is offline Windows 10 Office 2021
Novice
 
Join Date: May 2025
Posts: 1
Tonypolony212 is on a distinguished road
Default Letter mail merge only merging 70% of records

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
File Type: dotm 10 line merge.dotm (30.4 KB, 0 views)
Reply With Quote