View Single Post
  #3  
Old May 20th, 2004, 04:21 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Merge fields in Word updated automatically?

If you use the merge approach, you do have to recreate the output document
each time you change your Access data. but you could consider writing an
Access macro or VBA function to do that so you didn't have to open each Word
document manually and re-merge it.

If you are just using Insert database, make sure you choose the optin to
insert the database as a field (it will be a { DATABASE } field). Then, all
you should need to do is open each document, select its contents, and press
F9 to get the up-to-date data before printing. If necessary you could do the
same as above (e.g. write an Access macro/function to do this automatically)
or you could put an AutoOpen macro in each Word document to select all the
field and execute them.

--
Peter Jamieson

"Joe" wrote in message
...
Hello,

I am running Word 2000 along with Access 2000 (with
Windows 98se). I have a simple address database in Access
(FirstName, LastName, Street, Zip, etc.) and want to
create tables in Word by merging (or "insert database").
I can do such, but I cannot figure out how to get the
table to update automatically when I change something in
the Access file.

I want to have several printable formats of this
infomation from Access. The people's names and numbers
are constantly changing, and I do not want to have to
recreate each Word document everytime someone's info is
updated.

How can I get a merged table to be updated automatically
when a field in Access changes or is updated?

Thanks and make it a great day!

Joe