>Hi Russel.
>
>One last question -- each time it opens the document programmatically, it gives me a dialog that wants me to select the table. There is only one table in the list and it's ltr_data$ (this is an Excel spreadsheet called ltr_data.xls). I just click Ok and it goes on, but this is an irritant when printing form letters (and it requires me to make Word visible, which I'd like to avoid). Do you know how to get around this?
>
>Are you doing your testing with Word 2003? If so, the reason this is happening is because of the chage to ODSO that I mentioned earlier. It is documented:
>
>PSS ID Number: 324378
>
>SUMMARY
>Microsoft Word 2002 includes a new, undocumented optional expression [SubType] for the OpenDataSource method.
>
>Description of the OpenDataSource Method
>The new optional expression attaches a data source to the specified document, which becomes a main document if it is not one already.
>
>Sub OpenDataSource(Name As String, [Format], [ConfirmConversions], [ReadOnly], [LinkToSource], [AddToRecentFiles], [PasswordDocument], [PasswordTemplate], [Revert], [WritePasswordDocument], [WritePasswordTemplate], [Connection], [SQLStatement], [SQLStatement1], [OpenExclusive], [SubType])
>
>To find this information about the OpenDataSource method, follow these steps:
>In Word, point to Macro on the Tools menu, and then click Visual Basic Editor.
>In the Visual Basic Editor, click Object Browser on the View menu.
>In the Search Text box, type OpenDataSource, and then click Search.
>Optional [SubType] Expression
>The [SubType] parameter is an optional Variant that determines the method that Word uses to open a data source. It is one of the WdMergeSubType constraints. To have Word use the same connection methods as in earlier versions of Word, namely Dynamic Data Exchange (DDE) for Microsoft Access and Microsoft Excel data sources, use SubType:=wdMergeSubTypeWord2000.
>
>I am glad that you found the white paaper and code samples on my web site useful < s >. Those code samples should work without error in Word 2000. At least they did when I presented the session < s >.