[jughead028]

We have an Excel spread sheet generated weekly with customer details (several types of rows with different info on each row).

I have a series of word documents that I need to keep updated from this spread sheet.

I can't use hyperlinks as the spread sheet changes.

Each customer will have multiple rows, with some common fields and some unique to the type of info on that row.

I need to make a document keyed by the customer number and displaying the data relevant to that customer.

Questions:
1. Is it possible to update the Word document on opening with the data from the latest spread sheet which will be overwritten every week ?
2. Can the word document use the customer number as a key to extract only the data for that customer?

In the example word doc, I need to be able to change the company name, address, authorised officer, contact person (could be more than one of each), the classes and status and the list of assessors and their details.

Any of this info can change from one spread sheet to another.

[draceplace]

Hey Jughead welcome to TSG. One solution might be to use 'Mail Merge' and recreate these Word documents based on the Excel sheet. Mail Merge if I remember does want all the information on the same row.

The solution I would do ...Link or import spread sheet to Access and use the Reports. You really have a database and the sooner you treat it as such the easier this will be.

FYI - Don't put real email addresses in the documents you post here.