Auto Populate Word Document

[Scott]

I need help!
Here is the problem. I have a Word document which I want to fillin patient
data.
I would like to type in the patient ID number and have the Word document
fillin the patient's last name, first name and date of birth.
The data for the patient information is stored in an excel spreadsheet with
the columns Patient ID, Last Name, First Name, DOB.
Can someone please direct me to a tutorial of give me the answer?
Thanks
Scott

 

[Doug Robbins - Word MVP]

Create the document as a template and to the template add a userform on
which you have a combobox.

See the following pages of fellow MVP Greg Maxey's web site:

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

On the page that comes up with the second of the above links, you will find
information on how to populate a list box with information from Excel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP