I am downloading emp personal data from another system into Excel for our
employees to verify. I am running into problems with the dependents section
which can vary depending on how many dependents are listed. The Excel ss
shows 5 records for one emp while the next only has one. How can I get the
merge to understand that when the clock number changes to go to a new form?
The rest of the form works great but this is driving me nuts! I believe it
has something to do with the 'next record if' word insert but can't get the
correct syntax. It keeps merging the same number of dependents for each
record (page) and grabs the next available dependents to 'fill up' the
section.

Thanks for any help.