akcramblet
New Member
- Joined
- Jul 12, 2010
- Messages
- 10
Can I access my Outlook 2007 contact list from excel?
I'd like to insert an employee number in one cell and populate other cells with related information (First and Last name... etc) from my Outlook contact list. So far I've been getting away with Maintaining a whole other employee list in excel, but it's a pain.
I've looked into exporting the contacts to a table in excel, but I have thousands of them and it creates a whole other sheet to deal with. Is there a way for Excel to access Outlook contact information directly? (like a vlookup function).
It seems lots of people could use this sort of function.
I'd like to insert an employee number in one cell and populate other cells with related information (First and Last name... etc) from my Outlook contact list. So far I've been getting away with Maintaining a whole other employee list in excel, but it's a pain.
I've looked into exporting the contacts to a table in excel, but I have thousands of them and it creates a whole other sheet to deal with. Is there a way for Excel to access Outlook contact information directly? (like a vlookup function).
It seems lots of people could use this sort of function.
