[Jackieblue]

Hello,
I am not sure I really know how/when/whether to use New Record.
I have a spreadsheet with lists of of electricians' drawings - which are
batched.
I would like to do a mail merge in word into a table but so that the new
record happens only when the batch number changes. For example batch 1 might
have 10 drawings, batch 2 only 8.
Ideally I would like to merge into a word table, with a new table starting
every time there is a new batch number.
If that's not possible I would at least like to filter and merge only 1
batch at a time. Because of the way I am setting my table up, it is merging,
but starting a new single line table for every apartment number as opposed to
a 10 line table when the batch number changes.
What am I doing wrong ?
I hope my explanation is clear enough for somebody to be able to advise me.
Many thanks. Jackie