Hi all,

i am currently attempting to make a system that will produce a mail merged document depending on user input from a java application. At the momment i have created a ODBC connection which is used to link the mySQL database and access, then created a mail merge based on the queries i have created in Access. However this means i can not base the query on the user input.

It also means i have to use access, when all the data is held in a MySQL db could any one point me in the right direction? Is it possible to query the mySQL database directly and output the results to a preformated MS Word Template .

Any Help would be greatly appreciated,

Dan.