PC Review


Reply
Thread Tools Rate Thread

Automatic Labels: A Dream...

 
 
Peter Gilmour
Guest
Posts: n/a
 
      12th Apr 2008

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


--
Peter Gilmour
 
Reply With Quote
 
 
 
 
macropod
Guest
Posts: n/a
 
      12th Apr 2008
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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Peter Gilmour" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>
> Our office has many clients, and each client has thousands of documents
> which have to be indexed and labelled.
>
> Currently there is a 'master file index' for each client, which is a
> word document containing a table. One column of the table has the
> titles of all the documents we need to index. The others refer to page
> numbers and are not relevant here.
>
> We use a certain brand of labels for the folders in which hard copies
> of the documents are kept. In order to print onto these labels, we use
> a template which is also a word document containing a table whose cells
> are the correct size to print onto the labels.
>
> What I would like to do is have a way of automatically copying the
> title column from the 'master file index' to the table designed for the
> labels? I think it can be achieved using fields, but I'm not entirely
> certain.
>
> The idea is that next time we create a 'master file index' for a new
> client, the titles of all the documents we enter into it will
> automatically be copied to the label template, which can then be
> printed onto labels.
>
> Please help - until then I'm the guy that copies and pastes the
> document titles from one table to another!
>
> Pete
>
>
>
>
> --
> Peter Gilmour


 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      12th Apr 2008
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_lab...th_word_xp.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Peter Gilmour" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Our office has many clients, and each client has thousands of documents
> which have to be indexed and labelled.
>
> Currently there is a 'master file index' for each client, which is a
> word document containing a table. One column of the table has the
> titles of all the documents we need to index. The others refer to page
> numbers and are not relevant here.
>
> We use a certain brand of labels for the folders in which hard copies
> of the documents are kept. In order to print onto these labels, we use
> a template which is also a word document containing a table whose cells
> are the correct size to print onto the labels.
>
> What I would like to do is have a way of automatically copying the
> title column from the 'master file index' to the table designed for the
> labels? I think it can be achieved using fields, but I'm not entirely
> certain.
>
> The idea is that next time we create a 'master file index' for a new
> client, the titles of all the documents we enter into it will
> automatically be copied to the label template, which can then be
> printed onto labels.
>
> Please help - until then I'm the guy that copies and pastes the
> document titles from one table to another!
>
> Pete
>
>
>
>
> --
> Peter Gilmour
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic number fill-in on Labels Bridgett Microsoft Word Document Management 3 6th Mar 2010 11:54 AM
Automatic removal of data labels with 0 value in a chart RER-Robert-MI Microsoft Excel Charting 1 25th Nov 2009 02:57 PM
how do I change the automatic formatting on caption labels? =?Utf-8?B?Sm9uZXM=?= Microsoft Word Document Management 3 16th Aug 2005 02:47 PM
Automatic Text Labels in Charts =?Utf-8?B?TWVyZWRpdGg=?= Microsoft Excel Charting 3 25th Sep 2004 04:00 AM
Text Box automatic Labels alan Microsoft Access Forms 3 6th Feb 2004 06:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:11 PM.