I've done this using a SQL Server datasource but this is the first time that I needed to use Oracle.
This is the Word part.
.MainDocumentType = wdFormLetters
On Error GoTo ConErr
.SuppressBlankLines = True
.OpenDataSource "", , , , , , , , , , , gstrConWord, strSQLText, _
.Destination = wdSendToNewDocument
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!
Yes, the DSN works just fine. I can even get a recordset from Oracle into my program. The problem is with the Word mailmerge. I'm trying to avoid having to save the Oracle data to a SQL Server table or a Word doc to use for the mailmerge process.