Hi,

Apologies if this question has been asked before - please direct to an
appropriate post if it has :-)

I have a column of usernames in an Excel spreadsheet and I would like to
find the corresponding email address by taking the username and doing a
lookup on all the email addresses in a global address list (by comparing the
username in the spreadsheet and username in Outlook, and returning the email
address if a match is found).

Anyone have any ideas how I could do this - or even if it is possible.

many thanks in advance.