Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Outlook Member Of
- Thread starter BobBob10
- Start date
Hi Bob
I've never done it, but I would start by firstly looking at using VBA code & referencing MAPI objects to see if I could get to it that way, or if you have Active Directory there are plenty of VBS script examples out there on retrieving information such as email addresses from AD. However I am not sure whether this would get addresses for people external to your firm. Alternatively if you have access to the necessary contacts folder you could use Outlook's Import & export function and use that to export it directly into Excel.
Maybe quite not the answer you were hoping for, but I hope this gives this thread a start with other people being able to add more detailed info.
Asjeff
I've never done it, but I would start by firstly looking at using VBA code & referencing MAPI objects to see if I could get to it that way, or if you have Active Directory there are plenty of VBS script examples out there on retrieving information such as email addresses from AD. However I am not sure whether this would get addresses for people external to your firm. Alternatively if you have access to the necessary contacts folder you could use Outlook's Import & export function and use that to export it directly into Excel.
Maybe quite not the answer you were hoping for, but I hope this gives this thread a start with other people being able to add more detailed info.
Asjeff
- Status
Similar threads
- Locked
- Question
- Locked
- Question