As Paul implies Form Field drop boxes are limiting (the 25 item list limit is a particular brick wall) and as you would need to use VBA to do what you require in any case, then his suggestion of mail merge is a good one.

However if you are going to use macros then rather than use a form field for the dropdown, you could employ instead a userform with a list box or combo box populated from the Excel worksheet. The box could hold all the fields from each record and thus lookup wouldn't be required. The form fields (if you need to use them) could be populated directly from the columns of the userform.

See http://www.gmayor.com/Userform.htm and http://www.gmayor.com/Userform.htm.

For a more in depth explanation, see http://gregmaxey.com/Create_and_employ_a_UserForm.htm

If you want to get adventurous, you could limit the display by a selected initial letter, but let's not run before we can walk .

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com