Trying to merge more than one record to a page

[h20vrrq]

I have to mail merge of a long list of staff into Word document. The document has already been created and approved so I have to use it. It has been set up to allow two staff records per page, one in the top section and one in the bottom section. Both sections are identical.

I've tried several ways of doing the mail merge but the best I can get is as follows: -

Page 1 has staff A & staff B
Page 2 has staff B & staff C
Page 3 has staff C & staff D

When what I want is: -

Page 1 has staff A & staff B
Page 2 has staff C & staff D
Page 3 has staff E & staff F

I tried inserting a <next record> before the start of the second section, but it still gives me the A&B B&C C&D solution, not what I need.

How do I get the merge to do 2 records per page and to not duplicate them (the staff list contains no duplicates).

I am using Word 2003 on XP if this helps.

Thanks,

 

[macropod]

Hi h20vrrq,

Try running the merge as a label merge, with the «next record» field.


Cheers
[MS MVP - Word]