Hello,

I am pretty much a newbie when it comes to Mail Merge. I can do the basics but then I get brain ache.



I have attached examples of what I would like to be able to do.

I would like the categories that are in the excel sheet going across "C1 - C6" to be consistent with each document. However, these can change / be updated as time goes on.

I would like to be able to do so without having to type in the categories into the word document.

I can get it to return the marks specific for a person but I have to type in the category manually.

Help please.

Hope it makes sense!

Attached Files

	EXAMPLE.docx (13.0 KB, 12 views)
	example.xlsx (8.5 KB, 10 views)

The problem you'll have with doing what you've described is that Word uses the data in the first row in the Excel data source for the mergefield names to be used for all rows in that column. Accordingly, if you change the category names in Excel, the mailmerge won't recognize the data.

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