User input required when you programmatically attach Outlook contact list in mail merge operation in Word

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q286842
This article has been archived. It is offered "as is" and will no longer be updated.
When you attempt to use Microsoft Visual Basic for Applications (VBA) code to attach a Microsoft Outlook contact list as the data source for a mail merge main document, the operation does not run without user input as expected. Instead, you may be prompted to supply a valid user profile and to select a Contacts list to attach the data source.
This behavior occurs because the SQL statement causes the dialog boxes to appear even though the statement contains all the information that is required to identify the data source.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
WD2002 WD2003

Article ID: 286842 - Last Review: 12/27/2014 16:44:09 - Revision: 3.3

  • Microsoft Office Word 2003
  • Microsoft Word 2002 Standard Edition
  • kbnosurvey kbarchive kbbug kbmerge kbnofix KB286842