The mail merge code in the attached file ("Low Risk Recommendations.dotx") works but for some of the fields, it adds two rows into the table with the field names (see the two lines in orange in the file "Low Risk Recommendations.docx" which should not be there).

I have wracked my brain over it but cannot figure it out. Any help will be appreciated.

Attached Files

	Low Risk Recommendations.dotx (94.2 KB, 2 views)
	Low Risk Recommendations.docx (96.6 KB, 2 views)

You're getting the extra rows because you aren't testing whether the 'observation' field is empty before outputting both the header rows and the empty 'observation' data.

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

Thank you for your reply. I’m not sure I understand in full what I should do to fix the issue.

Thank you and best regards.

See attached. Either - or maybe both - of the field constructions in the document might meet your needs.

Attached Files

Operationl Audits Report Template.docx (94.9 KB, 2 views)

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

Thanks for the reply. Unfortunately, none of the two proposed solutions has worked.

In what way?

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

Thanks. The line with the field names still appears.

Is there a reason for doing a Directory/Catalogue merge this way?

Can you post a sample data source (anonymized, of course)?

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

Try the attached.

Attached Files

Operationl Audits Report Template.docx (94.0 KB, 0 views)

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

Thanks, I've figured it out. It was a problem with my dataset. I appreciate the time you have spent on this.