The problem with your mailmerge main document is that you're trying to use spaces and multiple tabs between the 'columns' to achieve the desired alignment instead of single tabs with appropriately-positioned tab-stops. This is basic document formatting. See attached update. I've also added the necessary logic to suppress the output of all the in-use empty rows your workbook has below the actual data, plus, I deleted the extraneous line-break after 'College' in the workbook (which was messing with the 'College' field name).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|