Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop down box
I would like to know if there is a way to get info from an excel document
into a drop down box in word. I want to use this to list my customers, so when the secretary sends a quote they can pick the company name from a drop down box, which will then populate the address and contact name on a different line. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop down box
Not from Excel necessarily, but see
http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Darrell" wrote in message ... I would like to know if there is a way to get info from an excel document into a drop down box in word. I want to use this to list my customers, so when the secretary sends a quote they can pick the company name from a drop down box, which will then populate the address and contact name on a different line. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop down box
Suzanne,
This works well with one line of information, but I am trying to insert the following: Comapny Name Company Address City, State Zip I we only have about 25 customers. Maybe word is not the solution to this. I am trying to take the redundece out of typing the customers names and address each time we need to send them a quote. Do you have any other suggestions? Thank you very much for all the help so far!!!!! Darrell "Suzanne S. Barnhill" wrote: Not from Excel necessarily, but see http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Darrell" wrote in message ... I would like to know if there is a way to get info from an excel document into a drop down box in word. I want to use this to list my customers, so when the secretary sends a quote they can pick the company name from a drop down box, which will then populate the address and contact name on a different line. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop down box
The beauty of the AutoTextList is that the list just contains the name of
the AutoText entry, which can include as many lines (or pages) of information as you like. So you create an AutoText entry that has the company name and address, but the name of the AT entry is just the company name or an abbreviation of it. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Darrell" wrote in message ... Suzanne, This works well with one line of information, but I am trying to insert the following: Comapny Name Company Address City, State Zip I we only have about 25 customers. Maybe word is not the solution to this. I am trying to take the redundece out of typing the customers names and address each time we need to send them a quote. Do you have any other suggestions? Thank you very much for all the help so far!!!!! Darrell "Suzanne S. Barnhill" wrote: Not from Excel necessarily, but see http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Darrell" wrote in message ... I would like to know if there is a way to get info from an excel document into a drop down box in word. I want to use this to list my customers, so when the secretary sends a quote they can pick the company name from a drop down box, which will then populate the address and contact name on a different line. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Form field | Microsoft Word Help | |||
Drop down list from another drop down list in Word? | Microsoft Word Help | |||
Drop down menu does not drop down | Microsoft Word Help | |||
Drag and drop editing in a doc won't work - I get circle-slash cur | Microsoft Word Help | |||
How does one get a drop down menu to drop down? | Microsoft Word Help |