extract users of a particular department

Outlook version
Outlook 2007
Email Account
Office 365 Exchange
#1
HI,

In my outlook there are 15k of email address (users) are there. and those users are pertaining to different departments. I'm trying to retrieve users those who are belongs to a particular department say "Civil Engineering" to a listbox using vba.

Thanks, Vinoth
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#2
I was testing this one last night, to see if I could filter first - Use VBA to Export Exchange GAL to Excel - and couldn't get that to work (could be user error :)). I could check each one and use an if to only get specific users, but I dont know that it's much faster, as you still have to touch each one.

I believe redemption can filter, which would speed it up. RDO - AddressList (but didn't have time to test it last night.)
 

Similar threads

Top