SQL to Word mail merge

[dupontv]

Hi,

From a SQL (MS SQL server 2000) store Procedure, i need to create a Word OLE object and do a mail merge on that word document.
I can open the Word application, open/create a file but ican't find the way to do a mail merge from a query in my DB. Could someone please help?


thank you
Vincent

[stuka]

Python has good COM/OLE integration available, and also handles DB connections (I presume it can handle MS SQL Server, though I've never seen it done). That should make it easy to run a DB procedure/query, get the results, then fill in the form appropriately.