You receive an error message when you connect to a mail merge data source by using the Mail Merge Wizard in Word

Article translations Article translations
Article ID: 318532 - View products that this article applies to.
This article was previously published under Q318532
Expand all | Collapse all

SYMPTOMS

When you try to connect to a data source while you create a Mail Merge document in Microsoft Word, you may experience one of the following symptoms:
  • After you select your data source in step 2 of the Mail Merge Wizard, nothing happens.
  • When you use the Mail Merge Wizard, you receive the following error message:
    Word was unable to open the data source.
  • When you use the Mail Merge Wizard, and you connect by using MS Query, you receive the following error message:
    ODBC Microsoft Access Driver Login Failed

    Could not find file file name.
  • When you use Microsoft Visual Basic for Applications code to perform a mail merge with external data, you may receive the following error message:
    Run-time error '9105'
    String longer than 255 characters
    Additionally, when you view the connection string in the Immediate window after you pause your code, only the first 255 characters of the string are displayed.

CAUSE

This problem occurs because Word cannot create a connection string that is longer than 255 characters.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 318532 - Last Review: December 13, 2006 - Revision: 2.1
APPLIES TO
  • Microsoft Office Word 2007
  • Microsoft Office Word 2003
  • Microsoft Word 2002 Standard Edition
  • Microsoft Word 2000 Standard Edition
Keywords: 
kbmerge kbprb kbemail kbnofix KB318532

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com