Originally Posted by fumei

Well, it is a little naive.

The names appear...where? Have the addresses appear...where? These things do not appear magically. Word has to be told where and how. YOU have to tell it where and how.


I am not trying to give you a hard time, just trying to give you a stretch of imagination. Say you have Dr. Jones. You type “J” and then “o”. OK. Now where is the “corresponding names” to appear? Right after? So you now have “JoJones”, the Jones following the Jo” you typed?

Now where does the address (assuming you CAN get it) appear? Following the “Jo” (or “JoJones”) ? Someplace else? If so…where?
If I type in a list box (or similar appropriate object) "Jo", the name "Robert Jones" appears in the list box and I click on it and the name "Robert Jones" is retrieved from the excel file and 'appears' in that place where the list box is, along with that doctor's address (which is in the excel file)

As you do seem to want to place data gathered from someplace else (lets say your Excel file) at some other defined location, yes coding is likely. How else are you going to tell Word where to put it? I figured that the placing of a list box (or similar appropriate object) would be where the name would 'appear'.

Regarding that, part of the build of logic would be to determine if the location to put an address is ALWAYS going to be the same place. Yes


As has been mentioned (using a userform) you not need to type in the names. You can definitely pick up your data from Excel.
If I could not have to go to excel, but just get excel come to me, that would make it easier.