Database/Word merge

[Heidi]

I want to a merge between an access database and Word that
is not an actual mail merge with letters etc, but
something like it.

I want to create fields in a word document that relate to
information in the access database like addresses in a
mail merge?

We have our data in presently in excel and are transfering
it to Access. I have a word fact sheet template that has
about 20 different fields that match up to the data. Is
there a way to interface these two pieces without getting
overly fancy and needing a programmer?

 

[Cindy Meister -WordMVP-]

Hi Heidi,

I want to a merge between an access database and Word that
is not an actual mail merge with letters etc, but
something like it.

I want to create fields in a word document that relate to
information in the access database like addresses in a
mail merge?

We have our data in presently in excel and are transfering
it to Access. I have a word fact sheet template that has
about 20 different fields that match up to the data. Is
there a way to interface these two pieces without getting
overly fancy and needing a programmer?

Only using mail merge, really. Otherwise, you need VBA. The
VBA isn't terribly complicated, once you understand the
basics. There is a "tutorial, sample" file on my website,
under the Special Merges topic dealing with "complex merges":
WdAcc97.zip

Excel was a bit easier, because there you could link text to
individual cells. What you could, perhaps, do is link the
Access data back into Excel (DATA menu), and keep on using
the method you always have, up to now, to bring the Excel
data into Word.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

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