PDA

View Full Version : Search Global Address Book using employee ID



kbsudhir
01-28-2011, 03:46 AM
Hi All,

I am using Office 2007.
I have a list of employees with their employee id on an excel sheet. I want to populate their email ids by extracting the same from the global address book of outlook.

How to go about doing this. Please guide.

Regards
Sudhir

JP2112
01-31-2011, 01:18 PM
This page has some code that should help you get started:

http://www.codeforexcelandoutlook.com/blog/2010/09/link-excel-cells-to-outlook-data-fields/