I have an adress-data-base in Access 97. How can I transfer a single record
to Word 97 (8.0)?

When I try to copy a single record, Word express it in tabular form; see
like Excel.

As I know therefor you need a VB-Module. Who can give me a solution for this
problem?

Many thanks for your help in advance.

Werfelweg 7/2
4033 Linz
Austria

You definitely don't need to do a VB module.  Although I can't give you any
sample code I can generally tell you what you have to do and tell you too
books for the future.

Basically you need to create a reference to word from Access.

'patial

Dim DocWord as word.document

set appword = createobject("word.application.8")

set docword = appword.documents.add(strfinaldoc) strfinaldoc = path and
filename

'using docword as the reference you can do anything in word.  Put your data
from Access in the document, searches, pretty much anything.  You can even
do this invisibly I think.  appword.visible = true or false

Que publishing Access 97, power programming by F. Scott Barker.
Better is, Access 97, Developer's Handbook, by Sybex

Both have lots of examples for all kind of work manipulations.
Hope this points you in the right direction.

Warren Harmon

I think your english is better than my german.....
Use Mailmerge:  Make a word document, and 'insert field' , where you want the
field from the database.  Identify the field from the database. This will make a
document with each and every record from the database.  You can select just one,
if you want.

If you want *just one* record/address, use a make-table query in Access  to
select the one address you want.   Specify that table as the source for your
inserted field in the Word document.

Good luck.