They are not users, only contacts, and they are not currently in AD (see associated post below). I will soon be tasking our developer with extracting contacts and DL's from our database, he has already done a feasibility test and we know it's achievable. I am just unsure of how to make the OU's easily available through Outlook. Our contacts and DL's are already categorised with business unit association and business unit association is not mutually exclusive.
The issue is that we have many 1000's of contacts and most of them are business unit specific so rather than have a GAL with all DL's and contacts for the entire organisation I would prefer to have a separate address book for each business unit containing their associated contacts and DL's, therefore, removing clutter and making their own contacts and DL's more accessible. Post to another group - "Putting this type of information into Outlook contacts and keeping it updated can be a pain. It would be easier to add the contacts into a dedicated OU in Active Directory and have the SQL data feed into that. http://technet.microsoft.com/en-us/library/bb123642.aspx explains some of how this could be done. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Condron Sent: Monday, September 17, 2007 7:14 AM To: Exchange Discussions Subject: Genius Connect All, MS SQL 8.00.760, Exchange 2003 SP2, Windows 2000 server SP4 - Windows 2000 Pro/Windows XP, Outlook XP/2003. I am currently looking at making available contacts from our MS SQL database in Outlook. I have come across Genius Connect and this seems to go some way towards a desired solution. http://www.geniusconnect.com/ Unfortunately we need to be able to pull distribution lists from the database and filter the view by department. I was also hoping for the updating to be a little more dynamic and be able to pull information from multiple DB tables to populate the address books. I am happy to use a public folder contacts container(s) and update these as part of the solution. I would be grateful for any input regarding Genius Connect, any third party solutions that will fulfil my requirements, suggestions on how it could be programmatically achieved. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Duro Sent: 10 October 2007 16:08 To: Exchange Discussions Subject: Re: Contacts/distribution list AD integration I'm not clear -- are these users and contacts already in AD ? If they aren't, then you're asking how to import them into AD and mail-enable them? If they are already in AD, why try to put the lists in Public Folders when they can be easily available in the GAL? ----- Original Message ----- From: "Mark Condron" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[email protected]> Sent: Wednesday, October 10, 2007 4:10 AM Subject: Contacts/distribution list AD integration All, Windows Server 2000 SP4, Exchange 2003 SP2, Outlook XP/2003. I am getting a developer to extract contacts and distribution lists from an SQL database to AD. All the contacts and distribution lists are flagged in the database as belonging to certain business units within our organisation. Contact and DL association with each of the business units is not mutually exclusive. I know it's possible to create an OU for each of our business units and then include all the DL's and contacts associated with that unit in that OU? Is it possible to display the contents of the OU as a public folder contacts list or include it in an address book displayed in the "show names from:" within Outlook? Any other approached would be gratefully received. I need to let the developer know how to sort, what format, and where to drop the extract from the database in AD. TIA -Mark _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
