I would like to create a table in an Excel document called "Members" with seven fields: Name, Addr1, Addr2, City, State, Zip, Tel#.

I have a word document called "Letter to Special Members". This includes a text letter. I would like to use this as a form. Apart from other form fields the form would have 7 form fields:Name, Addr1, Addr2, City, State, Zip, Tel#.



What I want to do is have the first field "Name" be a drop down list of the member's names. Once this was chosen the other fields would automatically be filled with the information in the Excel document.

I don't want this like a mail merge where multiple letters or labels are made. I want to specifically choose the member's name and get the form automatically filled out.

How can I do this?