Microsoft Word - repetitive text

ECB

New Member
Joined
Mar 3, 2009
Messages
46
I've been given a word document, it's about 12,000 words.

It's a report for clients and we issue say 200 of these a year.

In the report there are 5 "fields" that repeat through the document around 100 times in total. Client name, project name, inventory of subjects etc etc

What I want to achieve is type in each field once, and the rest of the report auto populates, referencing the field. The kind of thing that you can do in your sleep in excel.

IN word, I think some of the options are:

1) Bookmark and Cross Reference. For some reason, when I'm trying to fill the bookmark I often end up deleting it.
2)Link to an exernal file such as the cells in an excel spreadsheet
3) Insert a field - I'm struggling to understand docvariables

or is there another way using Visual Basic - or some other way, Ive always tried to avoid using word and writing in excel, but reluctantly I think there are other elements within this report that probably mean word is the right choice.

Any pointers where to look or help gratefully accepted!
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,515
For the 'input' fields, you could insert Word's FILLIN field, then bookmark that for cross-referencing purposes. From then on, pressing Ctrl-A, F9 will cause all the FILLIN fields to prompt for input and, as they're updated, all the cross-references to update also. No code required.
 

ECB

New Member
Joined
Mar 3, 2009
Messages
46
That's great thank you - that's almost there. The ctrl-A F9 doesn't seem to work on a Mac or I'm doing something wrong but I think I can work it out from there.

One other little issue you might be able to help me with - I seem to inadvertently delete the bookmark, actually, once I fix the prompting that won't be an issue as I won't be editing text, just inputting it.

Thanks again for your help.
 

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,515
On Macs, F9 should work without the need for Ctrl-A. If you bookmark a FILLIN field as suggested an update the content using the field's prompt, you won't have the bookmark deletion problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,517
Messages
5,602,117
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top