Copy Excel data to Word fields and retain fields

I want to set up an Excel 2003 worksheet as a database and copy values (name, date of birth, employer, etc) from there to three Word 2003 templates (questionnaire, letter and report), and to Access. I think the best way to copy to Word is to set up fields and cross references (I want to use the same item of data more than once in each doc) and send the data to the fields. I have succeeded in copying the data to the fields (see sample code below), but it replaces the field, and then the cross references don't work. Does anyone know of a way to copy across to Word without removing the fields?
Thanks.

Please Login or Register  to view this content.

Thanks snb. Finally got it to work after a few hours of trying. Actually, it worked the first time, but no more after that.
Eventually discovered that I also needed:

Please Login or Register  to view this content.

to make the entries update.

Excellent. Thanks again.

Is .fields.unlink supposed to remove DocVariables from a Word document. I put it into my VBA code, but the fields remain. Do I have to select the fields in the document first? If so,how is that done? I've been trying, but I can't get it.
I found this bit of code to try selecting Word text, but I keep getting a compile error: "Variable Not Defined" on "ActiveDocument" after "Start:=". I don't know how to define it. Using Office 2003.

Please Login or Register  to view this content.

Thanks, snb. I tried .fields.unlink again, and this time it decided to work. Hmmm...

This has raised another issue or two, however. I see that doing that has also removed the fields from my Table of Contents (and probably page numbers) in my Word doc. I will need these later. So I tried to use your code (thanks) to see if I could just remove some of the fields, but I got the same error: "Variable not Defined" on "ActiveDocument". I am using Option Explicit in the code, and it's Office 2003.

Also, I have used ".activate" about six times in my code, and "select" once (just to put focus into a particular cell before the code finished running). What should I use instead? (One of those .activates is just before .fields.update .fields.unlink)

Originally Posted by snb

But why would you like to 'unlink' ?

One of the documents filled from VBA is the template of what will eventually be a large Word document. When filled from VBA, there is still a lot more work to do on the document. VBA only puts some helpful bits of information in there (names, addresses, correct pronouns, etc). After the document is completed, it gets formatted by admin staff. They have had trouble with other fields in documents - although these were a different type. The trouble has come when they want to modify something in one of the fields, and it breaks links to other fields in the document, and that causes errors. So I thought it would be best to remove DocVariables when it gets to that stage.

You've got me thinking now, though. I wonder if DocVariables would give the same trouble. I'd better do some experimenting... or just wait till the thing is up and running, and see what happens.

These documents are sometimes sent to clients as Word docs as well (rather than PDF). I wonder if there will be any issues there.

Now, about not using .activate in VBA...?

Thanks AlvaroSiza. I had been hoping to do it through VBA so that no one would have to remember to do it, etc. I think snb might have talked me out of doing it anyway, as it might be OK to leave them there.