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?

Re: sort problems by Mary

Mary
Thu Apr 13 02:42:02 CDT 2006

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.

--
Ed Bennett - MVP Microsoft Publisher


--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"MyPrinterLady" <MyPrinterLady@discussions.microsoft.com> wrote in message
news:B356ACCE-9843-4446-A643-DB71AFE917C4@microsoft.com...
> 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?