Forums

by Silver Springs ... >> Thu, 29 Apr 1999 10:54:08 GMT

Hi
Has anyone got an easy way to mail merge data from a JADE database into a Word document ?

I create sub-directories, copy Word template documents and then invoke Word and present the one page Word document to the user -- all from within the JADE application.

Now how do I pull names and addresses etc from a specific JADE instance and have the data items appear in pre-determined places in the Word document ?

All ideas gratefully accepted.

SilverSprings....
silversprings@easyliving.com

by Craig Shearer >> Fri, 30 Apr 1999 0:08:34 GMT

You'd need to have bookmarks through your word document template, then use some OLE automation commands in an OCX to find the bookmarks and replace them with your desired text.

Craig.

by Paul Ainsworth >> Mon, 3 May 1999 22:58:00 GMT

Hi

The Cardinal Healthcare branch have developed this functionality. They have a module which has some classes (and ocx) which allow the definition of templates and then the creation of word documents which use the templates, extracting data from the owning object into the document.

The templates and documents are stored in the database and thus are available to all users as part of the system.

This module is available (for purchase unfortunately).

Let me know if you are interested.

Paul

by Gloria McFarlane >> Thu, 13 May 1999 12:08:48 GMT

Extract a file from your jade database containing the "Labels" you
wish to use as merge fields in the first line of the file (use tab delimited for excel, commas or tabs for a word data source file)
place your field data on subsequent lines using the same delimiter
open your main document in word (one you have formatted with the same labels)
open the file you just extracted as the data source.
if your labels have the same names as the fields in your main word document the work is done. If your main document is blank, just add mergefields from the drop down list and your content.
I have heard you can change word's existing merge fields with an ocx
but haven't found out which one yet