Mail merge Word documents from PHP/mySQL app

[cazzy123]

Greetings.

I have a PHP/mySQL application and I want users to be able to generate Word documents from the application that are customized based on their data in the SQL database.

Does anyone have any thoughts on setting up a mail merge type template in Word and then quering the database to import the data into the Word document? This approach I think is probably easier than having the app actually generate customized Word documents. Has anyone done this before?

Thank you!

[Hafkas]

There would be two ways to get this done - use com functions to control word from php and create a document with data pulled from mysql or get ODBC to connect to mysql so that you can use it as a datasource in a word mail merge.

The documentation on the com function has some user comments that have to do with word.