Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number of records in a merge (Word and XL 2000)

    Is there a limit to the number of records/data values that Word can handle when doing a merge from an XL worksheet ? If so, what is and is there any way around it ?

    Regards,

    PaulJ

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number of records in a merge (Word and XL 2000)

    I suppose you could run into RAM issues if you had many, many records. You can certainly break down your merge into some type of portion. If you've already got a column in Excel that, for instance, only has 5 different values in it, you can use Word's merge queries to choose just one of those values at a time. Alternatively, a lot of people will sort by zip code to save postage, you could do a range of zip codes at a time. Or just add a straight numbered column to your Excel file and merge 1-500, 501-1000 or whatever increments you want.

    The number of merge fields, the size of the file, etc. could all contribute if you're having difficulty. Remember that it's building a document for you and to suddenly build, for instance, a 1,000-page document could take a lot of resources.

    Make sure you're machine is as cleaned up as it ought to be:

    http://www.thewordexpert.com/cleanyourpc.htm

    and don't open anything that you don't have to while performing the merge. Reboot before you perform the merge if you're really having problems.

    Hope this helps.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Los Angeles, California, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number of records in a merge (Word and XL 2000)

    Word can actually handle a very large file size: Operating Parameter Limitations and Specifications

    Note the limit on number of columns as this may affect Excel imports if they exceed the number of fields/columns per record/row that can be handled by Word (capped at 63).

    I have had success with enormous merges from Excel to Word. Just be patient, it will probably crunch through the whole thing.

Posting Permissions

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