Making an org chart from Exchange, part 2.5

Here's a link to one of the samples I'm using while building this:

http://vbaexpress.com/kb/getarticle.php?kb_id=222

In the author's words:

Dumping the Global Address List (GAL) to Excel provides an list in a form that can be easily searched or summarized. I recently had a phone call that was garbled and I caught only a fragment of his mobile phone number. I was able to quickly find this person's details by searching the Excel list. Can also be used to find multiple addresses in the GAL or to filter the GAL by location.

Here's another:
http://msdn.microsoft.com/en-us/library/Aa201300

And another:
http://www.outlookcode.com/article.aspx?ID=40

And from the OutlookCode.com, above, links here:
http://www.slovaktech.com/code_samples.htm#DLToWord

Making an org chart from Exchange, part 2

So what I want to do is, like I said before, is build a report that displays an org chart for my organization.

In order to do this, I'm think I'm going to need to

• Figure out SSRS - I've done lots of Crystal Report writing in a previous life, so this should be more a matter of learning the UI
  
• Find the data lurking somewhere inside of Outlook
• Write a VBScript extraction routine inside of Outlook to push the data to a database source somewhere
• Write the report, being cognizant of the org structure of my organization, and how the data is grouped
  

Making an org chart from Exchange, part 1

I want to do this: