Automatic Labels: A Dream...

[Peter Gilmour]

Our office has many clients, and each client has thousands of document
which have to be indexed and labelled.

Currently there is a 'master file index' for each client, which is
word document containing a table. One column of the table has th
titles of all the documents we need to index. The others refer to pag
numbers and are not relevant here.

We use a certain brand of labels for the folders in which hard copie
of the documents are kept. In order to print onto these labels, we us
a template which is also a word document containing a table whose cell
are the correct size to print onto the labels.

What I would like to do is have a way of automatically copying th
title column from the 'master file index' to the table designed for th
labels? I think it can be achieved using fields, but I'm not entirel
certain.

The idea is that next time we create a 'master file index' for a ne
client, the titles of all the documents we enter into it wil
automatically be copied to the label template, which can then b
printed onto labels.

Please help - until then I'm the guy that copies and pastes th
document titles from one table to another!

Pet

 

[macropod]

Hi Peter,

Is there any reason your 'master file index' and label templates need to be in separate files?

If not, it would be a simple matter of using bookmarks and cross-referencing to achieve what you want.

If you do need to keep the files separate, it's still a case of of using bookmarks and cross-referencing to achieve what you want
but, in this case, the cross-referencing would be done via INCLUDETEXT fields. See Word's Help file for more details.

In either case, this would work best if your 'master file index' is set up as a document protected for forms. That way, it's easier
to make sure the bookmarks don't get deleted when the client data are updated.

Cheers

 

[Suzanne S. Barnhill]

Is there some reason you're not using a mail merge? Your table can certainly
be used as a mail merge data source. See
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm