sort problems

[MyPrinterLady]

Using Publisher 2000 and mail merge - large input excel files - sort sequence
is crucial but does not hold. Doing a 20K pice mailing and addresses print
out in basically no sequence at all - I've broken database down to 2000 names
at a time - it will print 10 in sequence, skip 20, print 10 in sequence, skip
10 then eventually goes back and randomly picks up skipped addresses. I know
the file is sorted going in. With mailings this big, this is a MAJOR problem.
Anyone know what's happening here. How to solve?

 

[Mary Sauer]

Help from Ed Bennett, MVP

Adjust the Mail Merge Batch Size.

There is a way you can set the number of records per batch using the
Registry (fix courtesy of KATMA)

Open registry using regedit.exe

Go to:
HKEY_CURRENT_USER\Software\Microsoft\Office\<Pub Version>.0
\Publisher\Printing

Create new "string value" called:
NumberOfRecordsPerBatch

Double click and set a value for your batch size.