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
 
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...
 
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
 
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
 
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...
 
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.
 
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
 
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.
 
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.
 
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.
Similar threads
Thread starter Title Forum Replies Date
L Error when exporting Sent Mail to Excel Outlook VBA and Custom Forms 6
HarvMan Exporting IMAP OST file to PST Using Outlook 5
O Carriage Return - Line Feeds - exporting Calendar events Using Outlook 0
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
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 Using Outlook 0
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
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
H Error in values when exporting report to Excel BCM (Business Contact Manager) 1
F Outlook 365 Group INBOX by date but not by date and time Using Outlook 1
A Links in email getting error message about group policy Using Outlook 4
Geldner Send / Receive a particular group via macro or single keypress Using Outlook 1
S Outlook 365 Shared mailbox contact group member numbers not matching Using Outlook 0
D Contact Group - Adding Bulk Addresses Using Outlook 2
A Any way to force sort by/group by on search results with VBA? Outlook VBA and Custom Forms 1
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
D Advanced e-Mail search on from/to contact group only searches for first 20 contacts in group Using Outlook 0
P Posts in Folder No Longer Group by Conversation Column After Search Using Outlook 0
P Shortcut Pane - add shortcut to Office365 group mailbox Using Outlook 1
R Validating a group of Checkboxes Outlook VBA and Custom Forms 2
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 4
M Group of emails Using Outlook 1
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
K Outlook 2016 - controlling IMAP OST size with Group Policy not working Using Outlook 1
M Outlook .com group does not show up in Outlook for office 365 home Using Outlook 3
ChrisK2 Send email to advertise@slipstick.com fails: "The group advertising isn't set up to receive messages from..." Using Outlook 3
A Created a personal group that now appears to be a public group Using Outlook 3

Similar threads

Back
Top