Mail merge - same staff member but showing multiple fields

[nhagan]

Hi,

I was wondering if someone could please help. I have tried using a mergefield code but it was relevant for 2010 office.

I want to create a mail merge from an excel workbook. The workbook contains staff and their absence record.

For each page, I want it to display the staff member and all their absences.

I can't figure out how to mail merge so that if it is the same staff member to display their absence and only move on to the next record if it is a different staff member.

I've attached an example Excel file.

[AliGW]

You have posted in the Word section but attached a spreadsheet - from what you have said, this is about setting up a table suitable for your mail merge in Excel first. Shall I move this to the Excel section for you?

[AliGW]

Administrative Note:

Oops!

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ame-staff.html