Mail Merge in Pages only prints one record from a Numbers spreadsheet that contains many.

I would like to migrate all of my most used documents to Pages but serious inadequacies persist. Users have been posting about the same problem for years with no guidance or any other response from Apple. What is the value of a Mail Merge function if it only prints one record from a spreadsheet? Other document systems have a "next record" function. Apple has provided no insight for its user base about when or if this mail merge problem will be addressed.