Hi Julie,

If you've got Excel, this would really be much easier to do there. Excel has built in functions for looking-up and returning data
from a table, without the need to resort to vba.

Cheers

If you create an autotext entry containing each email address with that
autotext entry having the corresponding name that would be in the list from
which you want the users to pick (actually assumed to be a DropDown type
FormField as you say that you are going to protect the document, you could
use the following code in a macro that is run on exit from the DropDown
FormField:

' Macro created 15-11-97 by Doug Robbins to add the address corresponding to
a drop down name

'

Set myDrop = ActiveDocument.FormFields("Dropdown1").DropDown

Company = myDrop.ListEntries(myDrop.Value).Name

Address = ActiveDocument.AttachedTemplate.AutoTextEntries(Company).Value

ActiveDocument.FormFields("Text1").Result = Address

End Sub

I would suggest however that you consider the use of a user form, but you
will have a bit of learning to do.  In the first instance, you should
probably work your way through the following articles

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136