ADO recordset as datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven Packard - 18 Aug 2004 17:11 GMT

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?

Reply to this Message

Peter Jamieson - 18 Aug 2004 20:51 GMT

> 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.

Signature

Peter Jamieson

> 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?

Reply to this Message