Word Mailmerge DataSources

2004-01-12 03:49:13 AM
I am rewriting an old app that originally ran against an MS Access DB. In
this old app, the user could select hundreds of records at once and ask for
each record to have a letter created via MS Word. Internally the app
creates a temp MS Access db and merges the records to it then opens MS Word
and starts a mailmerge with the temp db as datasource. For the most part
this worked ok.
The new app runs against an Oracle db. Given that users will still want to
be able to select hundreds of records and create a letter for each, what is
the best method of providing this data to MS Word? preferably without
creating a temp access db.