Filling Word template with data from multiple MsAccess tables

[KarinBerghuis]

Hello,
I'm trying to find out what is the most efficient way to fill a Word
template with data from 2 related MsAccess tables with a 1 to many
relationship. I work from a vb program. I see possibilities with automation.
Working with bookmarks in the template. Fill a Word table with the many
records. But is this the most effectient way or is it possible to let the
template fill itself with macro's?

 

[Cindy M -WordMVP-]

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

I'm trying to find out what is the most efficient way to fill a Word
template with data from 2 related MsAccess tables with a 1 to many
relationship. I work from a vb program. I see possibilities with automation.
Working with bookmarks in the template. Fill a Word table with the many
records. But is this the most effectient way or is it possible to let the
template fill itself with macro's?

I don't understand what you mean by this last question? You might want to see
the MSDN article on automating tables (search my name).

Another possibility COULD be mail merge, depending on exactly what you need to
do. It's possible to link a DATABASE field to a key field to generate a table
for the "many" side of the relationship. (See the mail merge FAQ on my website
for a link to an example of this, if you're interested.)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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

 

[KarinBerghuis]

Thanks a lot, i've learned a lot of new things about Word automation. I've
chosen to work with bookmarks and to fill a word table from vb. In this way
I'm able to influence the layout.

Karin Berghuis