I have an Excel spreadsheet with 135 records. Headings are:
Name, PersonalTimesBalance, VacationBalance, ReportsToName, e-mail, PreferredName
The last field, PreferredName is the key field the merge will be based on, AND grouped on.
Attached is the merge code, but when I click the "Preview Results" button, it's not grouping on the PreferredName; the record row under the table (in second image) should list 5 additional records for the PreferredName(which =Larry); the mailmerge record selector indicates 135 records as well.
What am I doing wrong with my code that it's only pulling 1 record on the PreferredName?