I am creating a report that require a person's name to appear in over 50 areas in the report. and the name to be obtained from a database.

I want to use bookmarks to insert the name, but I don't want to create that many bookmarks and write that much code to change one thing.

is there a good way or better way of doing this? I wish i could be able to have one bookmark point to all names, and change everything using one line of code, but the bookmark doesn't seem to work that way.

PLEASE HELP

Is there a way that you can produce the report within MS Access? The reason I am asking is because the topic indicates a Word report. If so, I can show you a quick way to populate as many name fields as you have quickly once you have retrieved the name of the person. If you have any examples of table name, column name, how the name is to be retrieved, it can be integrated into the sample code.

Thanks wscheiman for ur response

the code below is what i have so far
but i can only change one instance of FullName.
I tried using captions so I can have the same caption in multiple places in the
word doc, but caption was not recognized

It would be much easier to do it in vb, but I was instructed not to.
I WOULD APPRECIATE ANY SUGESTIONS OR ADVICE


Set objword = CreateObject("word.application")
  With objword
  .Visible = False
  .Documents.Open ("c:\maps\lkms\Template.doc")
  End With
With objword
    .activedocument.Bookmarks("FullName").Select
    .Selection.Text = rstTextBlock.Fields(1).Value
    '.activedocument.Caption("FullName").Select
    '.Selection.Text = rstTextBlock.Fields(1).Value
End With