How to use external data to populate multiple Word docs? RRS feed

  • Question

  • I have to create 7 different Word documents that contain many of the same data fields. Is there a way I could set up an Access db, Excel spreadsheet, XML, or text file, as a master list that contains all these data fields - then have the several Word docs refrence the one source? I'd also like it to be dynamic, so if I update the source, it updates all the fields in all the docs.

    I've spent hours trying to find a way to do this. Any help is greatly appreciated.

    Friday, June 24, 2011 8:46 PM


  • Hi benhenny,

    If you create a source document with, say, formfields for the common data, you can then have a number of other documents containing INCLUDETEXT fields that point to the formfield bookmarks in the source document. Each target document can reference as many or as few of the source document's formfield bookmarks as in want, in whatever order you prefer. See Word's Help file for details. Note: if you do you use a source document with formfields, be sure to include the \! switch in the target documents' INCLUDETEXT fields.

    Paul Edstein
    [MS MVP - Word]
    Monday, June 27, 2011 6:36 AM