We are trying to create a combo box that will populate various fields with information about the selected employee. The document is a check list of required actions by HR and supervisors of all employes separating from the company. We have a list of employee names, departments, hire dates, etc in Excel. We want a combo box on the Word document where we select the person's name and the various powerfields get the related information.

So, is this a mail merge with one record? How do you filter a merge to one person

Or is there a way to link with Excel using a combo box?

Anyway, maybe I should ask a more general question; what is the best way to accomplish this?

We are using Windows 7 with Office 10. I am an expert with VBA, but I have not used word in over a decade.

Thanks
Privateer