Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How can changing one field changes the others related?
Hi,
I am using Word 2003. I have a customer list containing the customers' names, titles and telephone numbers. I need to insert this information into a Word document. I hope to make a drop-down list in the document from which I can choose a customer's name and, after that, the phone number and title of the selected customer in the Word document can be updated automatically. Could someone help me with that? Thank you. Mike |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How can changing one field changes the others related?
On Fri, 22 Feb 2008 17:16:15 -0800 (PST), cyberdude
wrote: Hi, I am using Word 2003. I have a customer list containing the customers' names, titles and telephone numbers. I need to insert this information into a Word document. I hope to make a drop-down list in the document from which I can choose a customer's name and, after that, the phone number and title of the selected customer in the Word document can be updated automatically. Could someone help me with that? Thank you. Mike If you set up your customer list as a mail merge source document, you can easily "merge" one selected customer's data at a time into a main document that has merge fields. See http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm, http://www.word.mvps.org/FAQs/MailMe...DataSource.htm, http://www.word.mvps.org/FAQs/MailMe...AMailMerge.htm, and http://www.gmayor.com/mail_merge_lab...th_word_xp.htm. If you'd rather stick with your original plan (which will be more work), see http://gregmaxey.mvps.org/Linked_DropDown_Fields.htm for some techniques that will help. You'll need a macro similar to the one in the Linked_Dropdown article that runs when the user leaves the dropdown. Instead of filling up another dropdown, though, you want the macro to fill in either form fields or bookmarks with related data. Look at the macro that follows the line "Note: If you simply want to set the value of a single text field ..." which fills in one form field; the same kind of code can fill in two (or more) fields. The related data can be coded directly into the macro, as shown in the article, or it could be stored in a separate document, text file, or database; each of these choices would require slightly different code in the macro. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing a field into text | Microsoft Word Help | |||
How to auto-update REF fields if related ASK field bookmark is upd | Microsoft Word Help | |||
Changing field results without automatic change to the field? | Microsoft Word Help | |||
ref field length changing on update | Microsoft Word Help | |||
changing the "author" name in the properties field in al... | Microsoft Word Help |