Re: Merge fields in Word updated automatically?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 05/20/04 

Date: Thu, 20 May 2004 16:21:04 +0100

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" <anonymous@discussions.microsoft.com> wrote in message
news:152301c43db6$c9485700$3501280a@phx.gbl...
> 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

Relevant Pages

  • Access & MS Word
    ... Is it possible to use access data in a certain field to ... print a word document of the same name? ... maintain a database of all products and have separate (or ... Possible or wishful thinking? ...
    (microsoft.public.access.gettingstarted)
  • Re: Fields?
    ... Again, rather than jumping into the more advanced methods, start with the ... beginner articles and use the Forms toolbar. ... > downloaded the sample Word document and Access database zipfile from ... I have placed both the form and the database in the ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Word and databases
    ... but in a database interface. ... maintain a word document, which would be printed, binded, and distributed. ... This became a major inconvenience for the data entry staff, ... The third column lists the designations. ...
    (microsoft.public.office.developer.automation)
  • Re: [Info-Ingres] User Creation File
    ... Don't forget database privileges, ... Record Database Information ... for iidbdb created in Step 1 of the upgrade procedure. ... A file called users.sql is written that will recreate all users, ...
    (comp.databases.ingres)
  • Re: Sources for query parameters
    ... You can create new properties for the database, ... Set prp = CurrentDb.CreateProperty(PropertyTitle, dbText, ... the variable becomes part of the Word document and its value ... GetRootFolder = CurrentDb.Name ...
    (microsoft.public.access.queries)