If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ADO recordset as datasource
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? |
#2
|
|||
|
|||
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. -- Peter Jamieson "Steven Packard" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening an empty recordset | johnbertell | Running & Setting Up Queries | 4 | August 12th, 2004 06:35 AM |
Refering to a recordset | Richard | General Discussion | 2 | August 5th, 2004 01:48 AM |
Opening a recordset query | stevens | General Discussion | 2 | July 8th, 2004 01:08 AM |
!Recordset from a parameterized query, as the form's recordset. Problem on sorting... | Savvoulidis Iordanis | Using Forms | 2 | June 24th, 2004 08:52 AM |