In that case, my suggestion is that since everything is ready, just
experiment, i.e. merge to an output document and see how long it takes. If
you're concerned that it might take forever, try 100 records at first - that
should give you some idea of the likely run time. Then increase it (you may
find that there is sudden degradation at various points - if so, consider a
batch size that avoids performance degradation. If the whole thing seems to
run just fine, I wouldn't bother with the batching.

And yes, your description of the batching is what I meant. You can use a bit
of macro code to do several batches if you want.

Peter Jamieson

"Sandra Jackson via OfficeKB.com" wrote in message
...
Sorry, I've just re-read my original question and apologise for suggesting
this merge was to be emailed - the end result is to be printed.

Sandra

--
Message posted via http://www.officekb.com