MS Word mail merge: organise every nth record?

Question

The Excel file has seven records (rows). I would like to organise every three records together. Yet, the following code returns a calculation error.

{ IF { =MOD({MERGESEQ},3) = 0} "{ MERGESEQ }: { MERGEFIELD _record}" "" }

How can I fix the error? Thank you for any help in advance!

score 1 · Accepted Answer · 2020-07-09T19:03:21.103

1

It's probably because you have the = 0 inside the { = } field when it should be outside, like this:

{ IF { =MOD({MERGESEQ},3) } = 0 "{ MERGESEQ }: { MERGEFIELD _record}" "" }

Another thing that could cause a syntax error is the case where your Windows regional settings require you to use ";" instead of "," as a list separator (i.e. in that case you would need

{ IF { =MOD({MERGESEQ};3) } = 0 "{ MERGESEQ }: { MERGEFIELD _record}" "" }

edited Jul 09 '20 at 19:03

answered Jul 08 '20 at 14:36

Thank you! But another issue comes but it seems I couldn't insert a picture here. So I'd like to start a new question. – Tin Amaranth Jul 09 '20 at 11:35

MS Word mail merge: organise every nth record?

1 Answers1