Hi,

I have a spreadsheet with the user ID's. I would like to have a function which looks up the Global Address List and returns the email address.

There are 2 ways of getting the email address:

1. From GAL
2. From Active Directory

Can you please give me the sample code to do this.

Thanks in advance,
Sunder