HELP - Connecting to ADODB Datasource for a MaiMerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick - 21 Jun 2005 18:45 GMT

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 to this Message

Peter Jamieson - 21 Jun 2005 19:02 GMT

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

> Hello,
>
[quoted text clipped - 11 lines]
>
> Nick

Reply to this Message

Nick - 21 Jun 2005 20:59 GMT

That sucks. Thanks Peter. So then a .txt file will suffice??

Nick

> 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.
[quoted text clipped - 16 lines]
>>
>>Nick

Reply to this Message

Peter Jamieson - 21 Jun 2005 21:06 GMT

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

> That sucks. Thanks Peter. So then a .txt file will suffice??
>
[quoted text clipped - 20 lines]
>>>
>>>Nick

Reply to this Message