We help IT Professionals succeed at work.

SQL Based Address Book - Outlook, Exchange

Is it possible to have a SQL table act as a dynamic address book in Outlook for user's to pick and choose email recipient's from?
Comment
Watch Question

Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
never saw that features (but it would be interesting)
Hendrik WieseInformation Security Manager

Commented:
As far as I know this is not possible. Tried searching the web and cannot find any facts that this can be achieved.

Cheers!!!
Kevin GibbsIT Operations Manager

Author

Commented:
Thanks guys. I googled it a bunch as well and was just hoping I missed something. OK. I'll move on to plan B.
If you have SharePoint you could use a sharepoint "Contact" list
Kevin GibbsIT Operations Manager

Author

Commented:
Ugh...no sharepoint here!  
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
What is the need for an external address book?
Kevin GibbsIT Operations Manager

Author

Commented:
We have our membership database (about 4000 records) hosted by a third party.  they manage our website and membership management features...etc.  We have access to their API where we can keep a synchronized copy of the data on their servers with a table(s) on our SQL server for local application use.  So when a new member is added to our membership, that new member's information is also immediately available in our local SQL table so we can access their information for use on internal apps.

What my users are screaming about the most is the ability to be able to use an Outlook Address Book of some sort to still have access to all our contacts and distrubution lists etc.  They hate the idea of having to go to this website, log in, find the user, highlight, copy paste address to outlook, to send an email.  

I was thinking it would be fantastic if Outlook / Exchange had the ability to be able to point to a SQL table and have it act like an address book.

Make sense?

Kevin,

What version of Exchange are you running?

I had a thought, it's not pretty, and might require a bit more work on your part.  But you could easily sync up the sql table, export the CSV and use Powershell to create contacts in your AD. http://social.technet.microsoft.com/Forums/en-GB/exchange2010/thread/d8c4f96b-9963-4f6b-b384-e1237acdcf93

 
Kevin GibbsIT Operations Manager

Author

Commented:
We are still running on 2003, but will be running Ex2010 in a couple weeks.  Very interesting idea on a solution.  That just may work.
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
Don't know how committed you are you your current database system.... you could do all that with Sage ACT! - and there's even an add-on have it auto import/update from another SQL db
Kevin GibbsIT Operations Manager

Author

Commented:
2 really good thoughts guys.  Thanks so much.  let me do some digging around.
Kevin GibbsIT Operations Manager

Author

Commented:
this certainly does create a great deal more work, but it will do the job to accomplish our needs.  thanks!