Exporting group members from Outlook address group

Status
Not open for further replies.

pfluch22

Member
Outlook version
Outlook 2010 32 bit
Email Account
My Outlook 2010 address book contains a large number of groups, each with many members. Some of these groups contain a number of members whose entries are out of date. Rather than scrolling through the member lists I would like to export the members of the group along with their contact/location information to excel, to facilitate going through these lists. Excel is not necessarily a requirement, just need a reasonable way to even print out a list of the members.

Exporting the group to .txt just gives me the group name information, not the member info.

Ctl-A, Ctl-V does not work in this context.

My instinct says that there must be a way to do this.

Any help appreciated greatly!

E. Pfluch
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Open each group, press Forward, in internet format and open the resulting text attachment to get the names. Repeat. tutorial: forward a DL

If you have a large number, there might be some vba floating around the internet that will automate it, but the forward trick might be just as fast.

I've never tried selecting all DLs and using File, Save, as text... ooohhh... that worked in a quickie test with 2 DLs. Use Instant Search to show only DLs - the query will be messageclass:ipm:distlist - then select all, file, save...
 

pfluch22

Member
Outlook version
Outlook 2010 32 bit
Email Account
Thank you for your reply. When I do anything, all I get is the name of the group in a list.

I don't think this is a distribution list per se (I am new to Outlook) but looks like some kind of a subgroup, on which no actions that I can find are allowed. (See two screenshots below, if they are clear enough).

View attachment 353View attachment 354
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Ah, that is the address book & the GAL, not Contacts. I'll see what I can figure out with it.

select-dl-save-as-text.png
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Forgot I had an article on this - See How to print an Exchange DL. This only gets you halfway there - a list of names in the DL. (If you add all the DLs to a new message, expand all then paste into a new group, each name will be listed only once - helpful if many people are in multiple groups.)

I don't know what method would be easier/better for getting the contacts into excel, especially if they are in the GAL instead of in Contacts. I'll have to think on it.

If you have an idea who needs updated by looking at the list of names and email addresses, you could just stay in outlook...
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I know... bad form to talk to myself... but if that contact card annoys you, the legacygal key at Outlook Contact Cards might make this job easier. it's the section/key right before the video.
 

pfluch22

Member
Outlook version
Outlook 2010 32 bit
Email Account
Diane,

I very much appreciate your thinking out loud. I found a piece of VB code for Excel in my searches, it works, but it only returns the alias. I am trying to get First name, last name, title, department and office. (Apologies, as this is my first coding experience in 20 or so years (!) and I am trying to get back up to speed).

E. Pfluch

Function GetGroupUsers(ByVal strGroupName As String) As String

Dim objGroup, objDomain, objMember

Dim strMemberlist As String, strDomain As String

On Error Resume Next

Set objDomain = GetObject("ldap://rootDse")

strDomain = objDomain.Get("dnsHostName")

Set objGroup = GetObject("WinNT://" & strDomain & "/" & strGroupName & ",group")

For Each objMember In objGroup.Members

strMemberlist = strMemberlist & "," & objMember.Name

Next objMember

' strip off the leading comma

GetGroupUsers = Mid$(strMemberlist, 2)

End Function
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The problem is that DL's don't contain all that extra info - that's why I said that if you have an idea who needs updated, that looking over list in outlook is an option. Once you get the group members, you need to go through the list and get details. There should be code samples for that available online.

In addition, these groups are in the GAL, not in Outlook, so unless you are the admin, its going to be more difficult to update them. If you are comparing them to addresses in your contacts, I'd add them all to contacts - outlook should detect duplicates and you can compare the changes.
 

pfluch22

Member
Outlook version
Outlook 2010 32 bit
Email Account
Is this a reasonable thought for me to pursue:

If I REALLY REALLY want to get this as an Excel output AND

if I can use the above function to get the aliases for the members in each group

Can I then go back with those aliases and search the GAL for those aliases and extract the rest of the data that way (automatically, not manually)

I don't care if I get the entire entry, as long as I can tell who is who, whereas aliases are too alias-y.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Yes, to the best of my knowledge, if you have the aliases, you can push them through a different function and get full contact data. I don't have any code samples though.

What version of Exchange?
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
GregS Exporting contacts Using Outlook 1
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
R Exporting recovered Deleted Items outside the Inbox Using Outlook 1
N Exporting IM Address field Using Outlook 2
E Exporting email (.pst) Using Outlook 8
T exporting contacts names reversed in CSV file Using Outlook 8
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
D EXPORTING MS EXCHANGE EMAILS to another platform Exchange Server Administration 10
R Exporting contacts from 2010 to 2013 Using Outlook 1
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
A Exporting email in outlook 2013 with Office 365 Using Outlook 1
Diane Poremsky Fix the Outlook Folder Type after Exporting an IMAP Account New Slipstick.com Articles 0
V Unknown error when exporting to a PST Outlook Wishlist 2
V Exporting RSS Feed to OPML file Using Outlook 8
D Reoccuring appointment issues when exporting Calendar to Excel Using Outlook 3
B BCM 2010: Exporting Notes to .CSV with Business Contacts? BCM (Business Contact Manager) 3
Commodore Exporting all contacts to VCF files possible? Using Outlook 4
C Security Question - How to prevent users exporting .iaf files Using Outlook 5
C How to get SMTP out of email address when exporting contacts? Using Outlook 2
M Error Messages when exporting Outlook 2010 Contacts to a CSV (DOS) or Excel Using Outlook 2
R Exporting and importing contacts in Outlook 2007 Using Outlook 1
C extra characters added to email when exporting Using Outlook 2
P Exporting Calendar, Contacts & Tasks from Outlook 2007 to Outlook 2003 Using Outlook 5
S Problems with Exporting Data by *.pst Using Outlook 1
C exporting contacts from msn hotmail to outlook Using Outlook 2
S exporting failed deliveries Using Outlook 2
M Exporting the Notes field from Outlook Contacts to Excel Using Outlook 1
D Need help bulk exporting mailboxes Exchange Server Administration 3
D Exporting Contacts Using Outlook 5
R Exporting Contacts Error Using Outlook 4
M exporting personal folders from outlook Using Outlook 6
E Exporting all contact information from Outlook. Using Outlook 4
G Exporting Microsoft Outlook Contacts as CSV file Using Outlook 4
S Exporting wlm into Outlook 2007 Using Outlook 1
N Re: Exporting Outlook contacts via a CSV file into Hotmail Using Outlook 3
J Exporting Contact Groups in OL 2010 Using Outlook 4
K Exporting to PST Outlook 2010 Exchange Server Administration 1
R Problem exporting Exchange 2010 selsigned certificate Exchange Server Administration 3
R Exporting outlook 2010 tasks to excel Using Outlook 2
P exporting and importing email accounts Outlook 2010 Using Outlook 3
B Exporting Contacts in Outlook 2003 Using Outlook 6
N Re: Exporting Outlook History Using Outlook 4
F Oulook 2007 emails exporting Using Outlook 3
S Trouble exporting my Outlook 2003 Contacts file to another computer running Win XP Pro SP3 Using Outlook 3
H Exporting Outlook Forms to Access or Excel Outlook VBA and Custom Forms 2
F Outlook 2007 BCM Exporting Files BCM (Business Contact Manager) 2
T Automating Exporting to pst file Outlook VBA and Custom Forms 3
G exporting files from BCM BCM (Business Contact Manager) 1
G exporting from BCM BCM (Business Contact Manager) 1
D Exporting reports to Excel gives wrong numbers BCM (Business Contact Manager) 1
Similar threads


















































Top