ADO recordset as datasource

[Steven Packard]

The documentation regarding the mailmerge object proudly
states that it (mailmerge) can use almost anything as a
datasource, be it an Access table or query, a word
document, a spreadsheet, etc. I want to use an ADO
recordset as a datasource but have not been successful.
Can this be done?

 

[Peter Jamieson]

Can this be done?

Not with the built-in facilities. You either have to convert your recordset
to a file or data source in a format that can be opened via OpenDataSource -
which unfortunately I would imagine is the opposite of what you really want
to do, or, if you happen to be able to find or write an OLEDB provider, ODBC
driver, or Word text converter that knows how to connect to your recordset,
you might be able to do it that way.