Embedding excel field into Word form in order to auto populate.

[Mark]

I am creating a form in Word. I would like to be able to
enter a number in a field and the rest of the form auto
populate with the appropriate information from Excel. How
can I do this?

 

[Doug Robbins]

If you put the data into Access, then you could use the information in the
article "Access a database and insert into a Word document the data that you
find there" at:

http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm

If you see the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and then create a template containing a userform, you could use the
information in the article "Load a ListBox from a Named Range in Excel using
DAO" at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

To populate a listbox, or a combobox on the userform from which you could
select the ID and have code insert the data into the document.

Or you could make use of the information in the article "Retrieving Data
from a Named Range in Excel using DAO" at:

http://word.mvps.org/FAQs/InterDev/XLToWordWithDAO.htm


--
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