You should have all the fields for 'Kelly' on a single row in Excel. One column for 'FirstName', separate columns for each 'Subscription Period', separate columns for each 'Fund Name', and separate columns per 'Fund Name' per 'Subscription Period' for each of 'disbursement_netAmount', 'numCourses', & 'SumRegUnits'. Your mailmerge main document would then use mergefields referencing each of these column names for the relevant cells. See attached examples - you'll probably want to change the column names and associated mergefield names.

Attached Files

	FA Award Letter.docx (19.7 KB, 12 views)
	Test_Data.xlsx (8.9 KB, 13 views)

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