Excel to Outlook - too much for me

Could someone please give me some (maybe I should say a lot of) help? I've got a list of names in an Excel spreadsheet. These names are exactly the same as you would find in the 'Display:' box of the 'Outlook Properties' dialogue box if you right clicked on the name in the To/CC line on an Outlook email. For each name in the Excel list, I would like to go to Outlook and retrieve the named person's address fields and the named person's manager name and address fields, storing this data in adjacent columns on the Excel spreadsheet. Is this possible? Could you help with some of the coding? I've done some rudimentary VB coding of Excel macros and functions. Thanks loads.

Okay, I'm probably asking for too much. Can someone send me some code that would demostrate how I could call Outlook from Excel (passing a name as argument), get to the named person's manager, and pass that data back to Excel? Any help would be appreciated. Thanks.

Moved to Office Development forum