Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    San Diego, Idaho, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    WordMailmergeLimits (Word 2000)

    there appears to be a limit of bringing 10 fields into a document when the data source is ODBC. We have tried this on various versions of Office and Windows.
    When using Excel, there is no apparent limit. (We have imported as many as 100 fields.) If we bring fielsds into Excel first, they can hen be merged into Word--an extra, unnecessary step.
    any thoughts?

  2. #2
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WordMailmergeLimits (Word 2000)

    Excel can be, and is commonly, used as a Mail Merge data source. It's not unlimited, but can handle 256 fields per sheet.

    -Lenny

  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: WordMailmergeLimits (Word 2000)

    Dave,

    Actually you should be able to merge up to 63 fields via ODBC using the mail merge helper or if merging to a table, see MSKB Q142756 for instructions on setup. Word program limits allow up to 2000 fields -- see previous article and this one: MS KB Q168804

    You don't identify your data source, but if ODBC doesn't work, use DDE.

    I have successfully merged more than 70 fields from Access. Check these articles for pointers and use FreeAnswers to search for more information specific to your situation. This search interface is far more friendly than the MS Knowledge Base and it accesses the MS database.

    Good luck, and post more details if you need specific pointers.

Posting Permissions

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