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.

WdDoc.Bookmarks("Name").Range.Text = Cells(2, 1)