extract users of a particular department


New Member
Outlook version
Outlook 2007
Email Account
Office 365 Exchange

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

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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