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?

What you are asking for is not that difficult, it is fairly simple, but it does take effort and planning and very specific instructions. Specifics. Nothing vague.
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? 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. No? Then that adds another layer of complexity.

Again, believe it or not it IS (fairly) simple. It just needs to be very very very specific.

As has been mentioned (using a userform) you not need to type in the names. You can definitely pick up your data from Excel.

Thanks for everyone's input. I have enough to try and see if I can achieve my goal.

It's a whole lot more complicated than that. What happens if your database has Dr Robert Jones, Dr Martha Jones, Dr Fred Johns, Dr John Johnson, Dr Ian Johnston and Dr Ann Johnstone? How is typing "Jo" going to get you the required output? Even typing "Jones" or "Johns" won't give you a single match and presumably you don't want your code to choose one at random. The best you'll do in many cases is to obtain a list of possibilities from which you must choose. I ought to know - I worked with electoral rolls for 25 years...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes, that would be fine, I could choose from the list of "JOxxxx"

I think you are being a bit sardonic when you say "presumably you don't want your code to choose one at random."

But that's ok, I get that my ignorance might make me out to be simple.

So, "The best you'll do in many cases is to obtain a list of possibilities from which you must choose." would be a fabulous outcome.

Vic

Simple is not the term I'd use. Unaware, perhaps.

As I said "It's a whole lot more complicated". Word has no predictive text functions of its own, so whoever is going to code this would have to do so from scratch. It's not something I've ever contemplated or come across.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

"Unaware", I agree with that definition.
So what I am seeking is ..."a whole lot more complicated".
I can stop trying to solve this quest then.
Mail merge definitely did not give me what I wanted.

Cheers, and thanks for your time.

Vic