Hi,
I have several word 2003 letter templates which are currently used to mail merge data directly from my SQL Server 2000 database.
In order to cut down network traffic, i'd like to be able to output my resultset from SQL as an XML file and send it to the user to use for their mail merge.
Is this possible with Word 2003 and if so can anyone suggest how i go about it, in particular which OLE DB/ODBC provider i need to use?
Thanks in advance.
Cheers,
Leigh
Sure, if it has a microchip in it, it must be IT... Now what seems to be the problem with your toaster...?
I have several word 2003 letter templates which are currently used to mail merge data directly from my SQL Server 2000 database.
In order to cut down network traffic, i'd like to be able to output my resultset from SQL as an XML file and send it to the user to use for their mail merge.
Is this possible with Word 2003 and if so can anyone suggest how i go about it, in particular which OLE DB/ODBC provider i need to use?
Thanks in advance.
Cheers,
Leigh
Sure, if it has a microchip in it, it must be IT... Now what seems to be the problem with your toaster...?