Solved

Microsoft Outlook 2007 Nested Distribution List Export

Posted on 2013-01-29
4
901 Views
Last Modified: 2013-01-30
I need to export nested distribution list to excel/csv/access from Outlook 2007.
These DL's are not owned or maintained by me, and part of global address book of the company.

I require a nested extract to check if a user is part of the entire nested DL and if yes, by virtue of membership to which DL/sub-dl (including capturing of multiple instances).

Also, since, DL is dynamic, so I cannot work with a static database by creating a one time database manually for the DL's.

Kindly advise.
0
Comment
Question by:peeyushmiglani
  • 2
  • 2
4 Comments
 
LVL 47

Accepted Solution

by:
apache09 earned 500 total points
ID: 38832677
How many DLs are we talking about here

Can you just right click on them
Add to your contacts

Open he DL
Do the same for the nested DLs

then export them individually?
0
 

Author Comment

by:peeyushmiglani
ID: 38833974
1. Number DL's : 40 to 50 arranged in 5-6 level of hierarchies.
2. Yes, I can add the DL to my contacts, but not sure if it will help achieve the objective.

My objective for this task is as follows:

Email provided : abc@xyz.com

Search this email in the entire DL (nested levels) to list all the groups for which this email is member. Can be multiple instances.

Now, since DL is dyanmic, I would want to refresh my data each time automatically before running this search task.

let's say, i am doing this search activity in MS Excel, so need a connectivity that fetches me updated DL for me.

Please see, if you can advise something better.
0
 
LVL 47

Expert Comment

by:apache09
ID: 38836638
Well one thing is for sure

Your not going to be able to do this natively in Outlook

Likely you may find this functionality in a 3rd party Product, such as GroupID Resports

The product is listed here on SlipStick, along with some others
http://www.slipstick.com/outlook/contacts/outlook-and-exchange-distribution-lists/
0
 

Author Comment

by:peeyushmiglani
ID: 38838435
@apache09: hi. thanks. thats where i started from. don't have these third party softwares on the software list company has permitted to use and intall. thanks anyways.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question