The information in this article applies to:
SYMPTOMSA 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:
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.
CAUSEThis problem occurs when the .SQLStatement argument is omitted from the MailMergeOpenDataSource command. RESOLUTIONTo eliminate the prompt to confirm the data source, modify the macro to include the .SQLStatement argument, as in the following example:
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
Additional query words: 6.0 winword fox pro foxpro 7.0 word95 access sql mail merge mailmerge print dbase database word7 word6
Keywords : kbmacroexample |
Last Reviewed: October 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |