Q121611 - Confirm Data Source Dialog Displayed w/MailMergeOpenDataSource

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

REFERENCES

"Microsoft Word Developer's Kit," version 6.0, pages 579-580

The Microsoft Access ODBC Help files DRVFOX.HLP and DRVDBASE.HLP, which are located in the Windows SYSTEM subdirectory.

Additional query words: 6.0 winword fox pro foxpro 7.0 word95 access sql mail merge mailmerge print dbase database word7 word6

Keywords : kbmacroexample
Issue type :
Technology :