Microsoft KB Archive/121611

{|
 * width="100%"|

Confirm Data Source Dialog Displayed w/MailMergeOpenDataSource

 * }

Q121611

-

The information in this article applies to:


 * Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
 * Microsoft Word for Windows, version 7.0

-

SYMPTOMS
A WordBasic macro that contains the MailMergeOpenDataSource command to connect a Mail Merge main document to a FoxPro or Dbase data source displays the Confirm Data Source dialog box. For example, the following macro prompts you to confirm the data source:

Sub MAIN Q$ = Chr$(34) connect$ = "DSN=FoxPro Files;" connect$ = connect$ + "DBQ=c:\foxprow;" connect$ = connect$ + "FIL=FoxPro 2.5;" MailMergeOpenDataSource .Name = "c:\foxprow\foxuser.dbf", .Connection = connect$ End Sub WARNING: ANY USE BY YOU OF THE CODE PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this macro code "as is" without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

CAUSE
This problem occurs when the .SQLStatement argument is omitted from the MailMergeOpenDataSource command.

RESOLUTION
To eliminate the prompt to confirm the data source, modify the macro to include the .SQLStatement argument, as in the following example:

Sub MAIN Q$ = Chr$(34) connect$ = "DSN=FoxPro Files;" connect$ = connect$ + "DBQ=c:\foxprow\foxuser.dbf;" connect$ = connect$ + "FIL=FoxPro 2.5;" MailMergeOpenDataSource .Name = "c:\foxprow\foxuser.dbf", .Connection = connect$, .SQLStatement = "Select * from foxuser.dbf" End Sub For additional information, please see the following article in the Microsoft Knowledge Base:

"Q110334 WordBasic Examples Using ODBC: MailMergeOpenDataSource"