Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Merge field error (length field names) (2003/SP2)

    I don't know what the maximum length is. You might try the following:

    - Select Tools | Options...
    - Activate the General tab.
    - Tick the check box "Confirm conversion at open".
    - Click OK.
    - Go back to step 3 in the Mail Merge task pane.
    - Click the option to select another data source.
    - Navigate to the data source file, select it and click Open.
    - You'll be prompted for a method to connect to the data source.
    - Try one of the other options than the default OLE DB.
    - Proceed as usual.

    I'd guess that the original field names in the data source contain spaces. In general, I would recommend against using spaces in field names (and to keep field names short).

  2. #2
    New Lounger
    Join Date
    Feb 2007
    Location
    Australia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge field error (length field names) (2003/SP2)

    Edited by HansV to replace attached Word document with the picture it contained - saves the reader a few clicks

    Whilst upgrading from Word 2000 to Word 2003 we have encountered errors when merging documents. It only occurs on merge fields that have a long name. We get an error saying invalid merge field with the field name listed (example attached). The shorter names work okay. Does anyone have any idea of what the field lenth is, how many characters, or how to work around merging fields with longer names. The only alternative I have at the moment is to place users back on Word 2000.

  3. #3
    New Lounger
    Join Date
    Feb 2007
    Location
    Australia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge field error (length field names) (2003/SP2)

    Thanks for your reply Hans. I forgot to mention that it is not the typical mail merge data source but we have an interface that creates a new data source every time a precedent is run and the fields are taken from a SQL database. When I open a precedent to edit fields it is not actually attached to the data source until it is run from our interface.

  4. #4
    New Lounger
    Join Date
    Feb 2007
    Location
    Australia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge field error (length field names) (2003/SP2)

    We have now worked out the maximum field length is 38 characters after the words MERGEFIELD. Why the longer fields work with Word 2000 but not Word 2003 I do not know.

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

    Re: Merge field error (length field names) (2003/SP2)

    Thanks for the update, it's good to know.

Posting Permissions

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