extract users of a particular department

Status
Not open for further replies.

vinothjoseph

New Member
Outlook version
Outlook 2007
Email Account
Office 365 Exchange
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
 

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.)
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
N Extract Outlook emails to excel Outlook VBA and Custom Forms 2
M Extract all links from Outlook email, send to Excel Using Outlook 2
T Extract Data From Outlook Tasks Using Outlook 0
T Extract Data From Outlook Tasks Using Outlook 0
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
S How to extract mail items from multiple folders and shared mailboxes? Outlook VBA and Custom Forms 0
K Extract email address from body and auto-reply outlook Using Outlook 1
R Trying to extract information between two symbols from outlook subject Using Outlook 2
K Extract email to excel from a specific sender Outlook VBA and Custom Forms 3
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2
B Extract Dates for Appointment Item in Body of email Outlook VBA and Custom Forms 10
D Need to extract a line from a word attachment, and add it to the subject line Outlook VBA and Custom Forms 3
E Extract excel files from outlook Outlook VBA and Custom Forms 2
K extract certain text from an Outlook Email Message Outlook VBA and Custom Forms 2
D VBA Script to extract text matching specific criteria Outlook VBA and Custom Forms 1
M Extract text in existing message body for use in newmail items Using Outlook 17
M HELP--Extract Data from 2003 outlook transfer to excel spreadsheet Using Outlook 1
M VBA Code to extract data from an Outlook Form Using Outlook 0
M Extract attachments with a script Using Outlook 0
M HELP - Can't open outlook... How can I extract my Emails that I had in folders Using Outlook 3
H Extract emails from Outlokk 2007 email body Using Outlook 0
K Extract Global Address List Using Outlook 1
E I am trying to extract the email adress's i have in outlook. These are not saved 'contacts' these are ones from auto fill. When i open up an email, an Using Outlook 1
L How to extract table format of Task Item if its body contains formatted table. Exchange Server Administration 1
D Extract email addresses from inbox in a batch and move them into "bcc" for a mass email campaign Using Outlook 1
M Extract, zip and replace attachement in each message of a pst file Using Outlook 0
R Saving Outlook Email As Text File Extract Outlook VBA and Custom Forms 2
N Programming to extract automatically extract attachments Outlook VBA and Custom Forms 3
S How to extract outlook calendar data. Outlook VBA and Custom Forms 3
? outlook attachment Extract File ??? Outlook VBA and Custom Forms 1
D Extract Data from OST File Using Outlook 2
N How to extract date and time stamp from messsages Outlook VBA and Custom Forms 6
V Extract Subject,Sent From, Message from mailbox to Excel Outlook VBA and Custom Forms 5
S Automatically extract attachments? Outlook VBA and Custom Forms 1
I How to extract email addresses from TO or CC line of a particular email Outlook VBA and Custom Forms 2
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
G Updating VbaProject.OTM on several users Outlook VBA and Custom Forms 3
M How can we find the list of users who are members of a deleted distribution list? Exchange Server Administration 2
D Can Exchange Admin Center create a pst for users email/contacts/calendar? Exchange Server Administration 0
Z Tasks from some users show up as emails Using Outlook 4
E Apply customized Business Card for all users Outlook VBA and Custom Forms 0
Diane Poremsky Add to Safe (and Blocked) Senders for Users New Slipstick.com Articles 0
K Remove Manage APPS button for users Exchange Server Administration 1
Diane Poremsky Prevent Users From Choosing Stationery New Slipstick.com Articles 0
T Outlook.com calendar as Group Calendar for Outlook 2013 users Using Outlook.com accounts in Outlook 2
I Different users connected to an IMAP email aren't syncing with each other Using Outlook 5
smokiibear Share Office 365 Tasks such that Other Users also Are Alerted with Reminder Using Outlook 1
B Push Quick Parts to All Users Using Outlook 1
D Preventing users to disable an Outlook Add-in Using Outlook.com accounts in Outlook 5
Similar threads


















































Top