Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Location
    Pleasanton, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merging to a single print job (2003)

    Greetings:

    I'm running a mail merge in Publisher 2003 using an excel spreadsheet of about 500 records as the data file. For some reason, publisher insists on sending 50 jobs of 10 records each to the printer. Does anyone know why it wants to do this, and how to tell it not to. The reason it's becoming a problem is that I'd like to print the records in reverse order, and since it insists on sending the data in batches of 10, I end up with 10 to 1, then 20 to 11 and so on.

    AdThanksVance,

    Murad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Merging to a single print job (2003)

    See The Registry Fix for changing the Mail Merge Batch Size. For your situation, you'd want to set the value of NumberOfRecordsPerBatch to 1000 or so, so that all records are printed in a single batch.

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Location
    Pleasanton, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merging to a single print job (2003)

    Hans:

    Thank you very much.

    I turned my data file up side down, and let publisher do it the way it wanted to, so I have not tried what you suggest at this time. Will let the group know if it does not work.

    Once again thank you very much for the prompt response.

    Murad

  4. #4
    New Lounger
    Join Date
    Dec 2002
    Location
    Pleasanton, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merging to a single print job (2003)

    Hans:

    The article references a setting of 0 (zero) to mean all records .I tried that, and it did not seem to work. So I set the registry key to a value large enough for me, and it work very nicely.

    Once again, thanks

    Murad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •