Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

Repetitive automatic field entry

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Damian - 15 Sep 2004 01:37 GMT
If we have, for example, a customer name that appears
multiple times in a standard document, how do we creat a
field so that the name only has to be entered once and
the rest of the entries automatically update?

Thanks in advance

Damian
Greg Maxey - 15 Sep 2004 01:51 GMT
Damian,

See:  http://gregmaxey.mvps.org/Repeating_Data.htm

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> If we have, for example, a customer name that appears
> multiple times in a standard document, how do we creat a
[quoted text clipped - 4 lines]
>
> Damian
Doug Robbins - 15 Sep 2004 02:02 GMT
Hi Damian,

There's a number of ways.

If you have a document that is protected for forms and a formfield into
which you enter the company name, at the other locations in the document,
you can insert a cross reference to the text of the bookmark that is
assigned to the formfield.  Then if in the Properties dialog for the
formfield, you have checked the "Calculate on exit" box, the cross
references will be updated with the information entered into the formfield
when you exit from the field.

Alternatively, you can used the File>Properties dialog to create a Custom
Document Property into which you enter the Company Name and then you can
insert DOCPROPERTY fields where-ever you want the name to appear.

If this is something that you need to do constantly with a number of
documents, then you should create a template in which you have an autonew
macro that either calls a userform (if there's more than just the company
name that you want to enter) or calls and InputBox using the Visual Basic
InputBox command to display an input Box into which the user enters the
company name and then set that information either to a Document Variable or
a Custom Document Property and display it in the document by means of a
DOCVARIABLE or DOCPROPERTY field as applicable.

For the userform approach, see the article "How to create a Userform" at:
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> If we have, for example, a customer name that appears
> multiple times in a standard document, how do we creat a
[quoted text clipped - 4 lines]
>
> Damian
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.