Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word 07 populating issue

Status
Not open for further replies.

Battista528

Technical User
Mar 26, 2009
2
I have a word document that I need to populate using another source either excel or another page from word. I am wondering how I would go about doing that. I need the same text along with other text added to many areas in the document. any help would be appreciated.

Tony
 
Hi Tony,

It really depends on what you're doing.

For example, you could use mailmerge if you're producing lots of letters with the same basic text.

Alternatively, if it's a periodic report, you might use links between your target document and an Excel source file.

Before giving firm advice, we'd need more details.

Cheers

[MS MVP - Word]
 
I have a form that on every page(24 pages) i need the name to populate and on some of those same pages i need other info to populate as well. I would like to have a cover page where you input the info(excel or word) and then it populates the form. it is not going to be large amount of of letters. Can it all be in the same file as well. I had started a VB project but wasnt sure if that would do what I need it to or if there is an easier way to do it.let me know if you need any other info. thank you for your help.

Tony
 
It's not very clear what you want to do. You have posted twice and stated two different requirements.

marcropod's suggestion of mail merge could work.

Or, you might need {ASK} and {REF} fields.

Certainly no need for VBA.
 
Yes, please be clear about what you want to do.

If the repeating text is entered into a formfield (say, named "Client"), then if that formfield property "Calculate on exit" is checked:

1. go to where ever you want it repeated
2. press Ctrl-F9
3. type "Client" (no quotes)
4. move the cursor to another location

Done. Protected for forms, once text is entered into the "Client" formfield, its text will be repeated in all other fields that point to it (via the steps above).

This is essentially the same as using a REF field. You can do this as many times as you want. So that one formfield ("Client") text can be repeated 40 times if you like.

Other than that, please try and be explicit in what you want to do. Do you actually need a source file like Excel? Do you want to include text from another Word document? In which case, look at using INCLUDETEXT. Or, as it has been suggested, use MailMerge.

Gerry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top