Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HELP - Connecting to ADODB Datasource for a MaiMerge
Hello,
I am trying to make a connection to a datasource that is an ADODB Recordset in VB 6. I have been trying with no success. I have found half answers on how to connect to .txt and .xls. datasources but nothing on a recordset. I have an ADODB Recordset that is created from a query executed from a user. I need to take that query result and then mail merge it with a word document. Does anyone know how to do this to help me out? Is this even possible? Thanks Nick |
#2
|
|||
|
|||
No, you can't merge directly from an ADO recordset - you have to save the
data to some sort of disk file in a format Word can work with. Peter Jamieson "Nick" wrote in message ... Hello, I am trying to make a connection to a datasource that is an ADODB Recordset in VB 6. I have been trying with no success. I have found half answers on how to connect to .txt and .xls. datasources but nothing on a recordset. I have an ADODB Recordset that is created from a query executed from a user. I need to take that query result and then mail merge it with a word document. Does anyone know how to do this to help me out? Is this even possible? Thanks Nick |
#3
|
|||
|
|||
That sucks. Thanks Peter. So then a .txt file will suffice??
Nick Peter Jamieson wrote: No, you can't merge directly from an ADO recordset - you have to save the data to some sort of disk file in a format Word can work with. Peter Jamieson "Nick" wrote in message ... Hello, I am trying to make a connection to a datasource that is an ADODB Recordset in VB 6. I have been trying with no success. I have found half answers on how to connect to .txt and .xls. datasources but nothing on a recordset. I have an ADODB Recordset that is created from a query executed from a user. I need to take that query result and then mail merge it with a word document. Does anyone know how to do this to help me out? Is this even possible? Thanks Nick |
#4
|
|||
|
|||
Should do, and it has the virtue of simplicity, but I would check with real
data, especially if you have multiline data or data with commas, double quotes etc. Word sometimes has difficulty recognising the delimiters and there's no way to specify them in code. If you're already familiar with coding with ADO it might be worth using ADOX to create a .mdb and table and ADO to populate it. Peter Jamieson "Nick" wrote in message ... That sucks. Thanks Peter. So then a .txt file will suffice?? Nick Peter Jamieson wrote: No, you can't merge directly from an ADO recordset - you have to save the data to some sort of disk file in a format Word can work with. Peter Jamieson "Nick" wrote in message ... Hello, I am trying to make a connection to a datasource that is an ADODB Recordset in VB 6. I have been trying with no success. I have found half answers on how to connect to .txt and .xls. datasources but nothing on a recordset. I have an ADODB Recordset that is created from a query executed from a user. I need to take that query result and then mail merge it with a word document. Does anyone know how to do this to help me out? Is this even possible? Thanks Nick |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find datasource except when the main doc is open. Where is i | Mailmerge | |||
Using Secured Access Database as Datasource | Mailmerge | |||
cant open mailmerge datasource | Mailmerge | |||
word 97 mailmerge with paradox files as datasource | Mailmerge |