I am using Excel 2003. I have a worksheet with names and email addresses.
In this worksheet there are some people with the same name, so I need to be
able to do some sort of lookup on a name which produces all the possibilities
lets say name, identity number, email address which are selectable from a
list in a userform.

Ideally I need to be able to transfer the result from Excel into Word

Is this possible, if so, can someone assist me with some code, please?