How Do I Create a word document to have data entered from a databa

[Guest]

How do I create the fields in a word document to accept data from a database.

I want to be able to export data from the appripriate database fields into
the word document with similar fields within the text......

Example.......

It took "X" light years to travel.....etc.............X will be the data
from the database?

Any simple example or link to an example that I could experiment with would
be appreciated.

Thanks
Dermot

 

[Cindy M.]

Hi =?Utf-8?B?RGVybW90?=,

How do I create the fields in a word document to accept data from a database.

I want to be able to export data from the appripriate database fields into
the word document with similar fields within the text......

Example.......

It took "X" light years to travel.....etc.............X will be the data
from the database?

Any simple example or link to an example that I could experiment with would
be appreciated.

Unless you use mail merge (functionality is in the Tools menu) there is no
"simple" way to do this. It requires VBA programming, with the code either in
Word or in the database. You'll find an example of this with a bit of
explanation, using Access as the database, in the WdAcc97.zip file you can find
here

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg

If you want to follow up on this approach, I suggest you ask in one of the
word.vba newsgroups.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Guest]

Thanks for this Cindy,
I thought this might be the case.
Thanks for the link to the example
have a nice day

Dermot Hayes
=?Utf-8?B?RGVybW90?=,