text in more than one location

[Mr widgetron]

Whats the easiest way to have one location in your document , where you can
enter details and have these details duplicated automatically at another
location in the same document.
Is this possible ?

Thanks in advance

 

[Joseph Meehan]

Whats the easiest way to have one location in your document , where
you can enter details and have these details duplicated automatically
at another location in the same document.
Is this possible ?

Thanks in advance

I think we will need a little more information about what you want. You
could use properties, hyperlinks, database fields. Lots of possible tools,
but which one of any will help you, I don't know.

 

[Mr widgetron]

I have a five page document based on a template.
What i want to do is enter the description of an article at a pre determined
location on page one and have it duplicate at two other locations
in the same document automatically, on the fly.

 

[Joseph Meehan]

I have a five page document based on a template.
What i want to do is enter the description of an article at a pre
determined location on page one and have it duplicate at two other
locations
in the same document automatically, on the fly.

How about using a data merge. Create a set of merge fields based on the
number of items you are going to want in your letter. One field for each
entry (even if you will use the entry many times.) Then create a Word merge
document inserting the merge fields as needed (e.g.. add the field "account
number" or "name of product" in every place in the letter/document you want
the account number or the name of the product to show.

Have the user start by entering the data into the Word merge data (a
special simple data base used by word for mail merges and containing the
fields you just made) then display the document. It will have all the data
in all the spots you want.

If you want to make more than one letter, you can have a new record in
the database for each different record and Word will do them all at one
time.

Read up on Mail Merge in the Word help files.

 

[Mr widgetron]

I think having to enter data into a seperate database would defeat the
object of trying to simplify the process.
There has to be a simple way surely ?
What about database fields ? or the hyperlink arrangement you mentioned.

 

[Mr widgetron]

Is it possible to have a text box where you would enter information into a
database and other text boxes which display that database field ?

 

[Joseph Meehan]

I think having to enter data into a seperate database would defeat
the object of trying to simplify the process.
There has to be a simple way surely ?
What about database fields ? or the hyperlink arrangement you
mentioned.

The database is part of MS Word. I have not played with the idea, but I
would guess you could do some tricks with macros to integrate the process to
simplify it for the users.

I mentioned the hyperlinks because they can be very helpful when you
want someone reading the document on a computer to be able to access
additional detail about a subject, or to provide a way of directly going to
a section in a document from an index page. Since I don't really know what
you are doing, I just make some real general comments about a few of the
many features of MS Word.

I might suggest that it is often easier to teach the user how to really
use the product than to come up with work a rounds. They tend to resist it
at first, but once they learn, they really like it and find they can use it
in other ways themselves. It is a struggle at first, but it pays off in the
end.

 

[Mr widgetron]

Doesnt anyone else have an idea on this , give us a hand here !
Please.

 

[Peter J Elliott]

I have tried to do the same thing but to no avail!

I also have a number of document templates that require the same data entry
in a number of different locations throughout. It would appear to be so
simple - just link however many form fields that require the same entry such
that when an entry is typed into the first box it automatically appears in
the 'linked' form fields.

There has got to be a way - hasn't there?

Peter

 

[Joseph Meehan]

Doesnt anyone else have an idea on this , give us a hand here !
Please.

You can do almost what you want with the built in database functions and
mail merge.

Create a document/template mail merge. Make the database with the
number of fields you will need, one for each different piece of data.

You can set it up so when the document/template is opened, the database
is opened to an entry form asking for the repeated detail information. When
done close the input form and the document can then show the correct data in
each location you want and the document may be edited.

You can even put in several sets of data to allow different versions of
the document to be printed at the same time.

You should be able to do with just a little macro work, and if you are
up to VBA you should be able to do a very professional looking job.

However I still suggest teaching the users how to use the tools they
have.