WORDING

[Ransom]

Hi everyone,
I am using an issue database that tracks customer complaints. I would like
to take it a step further and have each record stored produce a word
document. it needs to be something simple, ie the user can click a button
and the form is automatically generated based on that record....any
suggestions on the BEST way to do this?

Thanks
Ransom

 

[KARL DEWEY]

I personnaly would use Access database with Word mail merge. Data is loaded
in Access and pulled out using a query and the Word document.

Word Mail-Merge--- Open a blank Word document, click on menu TOOLS -
Letters and Mailings - Mail Merge. It opens an additional window on the
right and has step-by-step instructions and choices. You can also backup in
the process. Works fine for me.

 

[Albert D. Kallal]

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the follwoing page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try.