Are you saying a single field in the database contains records with:
^Total^Fall^Spring
Award 1^$2,000
Award 2-Award^$1,000
Award 3 etc.^$500
If so, that seem to be a particularly poor database design.

That said, your description suggests you're running the reformatting macro at the wrong point and/or against the wrong document, i.e. running on the mailmerge main document instead of on the merged output (post-merge).

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