none
Link SQL Server Table containing Email Addresses to Outlook RRS feed

  • Question

  • I have a remote SS Table of email addresses to which I would like link to Outlook as an External List.

    The SS Table will constantly change.  Am I able to create an External List within Outlook (2010)?

    The SS Table is maintained by an ASP.Net application but given that I can achieve the above within Outlook I see no reason to create something specific in that application.

    Monday, September 3, 2012 6:45 PM

Answers

  • Yes and no. It does use SQL Express, the only customizations you can do are what's supported by BCM and using your own database or tables is not supported.

    --
    Ken Slovak
    [MVP-Outlook]
    http://www.slovaktech.com
    Author: Professional Programming Outlook 2007
    "eharford" <=?utf-8?B?ZWhhcmZvcmQ=?=> wrote in message news:50cbfadb-b735-4035-97af-7e899f639994...
    Am I right in thinking that Business Contact Manager for Outlook 2010 uses a form of SQL Server Table as its data source? If so can it be configured to use my specific table? With thanks.

    Ken Slovak MVP - Outlook
    Thursday, September 6, 2012 3:50 PM
    Moderator

All replies

  • There is nothing that will help you do that out of the box - you will need to write a custom, MAPI address book provider in C++ or Delphi.

    Dmitry Streblechenko (MVP)
    http://www.dimastr.com/redemption
    Redemption - what the Outlook
    Object Model should have been
    Version 5.3 is now available!

    Monday, September 3, 2012 7:33 PM
  • not sure what SS table is but have you looked at how outlook can display sharepoint lists? is such functionality suitable for you?
    Tuesday, September 4, 2012 4:05 AM
  • Sql Server Table - I have not explored SharePoint, could you give me a URL which might elaborate? Thanks
    Tuesday, September 4, 2012 9:20 AM
  • generally look for stssync protocol description - this is what outlook uses to communicate with http server (it does not have to be sharepoint, you can handle this yourself and just return data in proper format) and outlook will display it.
    Tuesday, September 4, 2012 1:46 PM
  • Am I right in thinking that Business Contact Manager for Outlook 2010 uses a form of SQL Server Table as its data source? If so can it be configured to use my specific table? With thanks.
    Thursday, September 6, 2012 9:13 AM
  • that is just wishful thinking. Either create add-in that will display your data in the way you want or use existing functionality that outlook uses to communicate with sharepoint (and possibly other apps) and displays data in standard outlook way.
    Thursday, September 6, 2012 12:32 PM
  • Yes and no. It does use SQL Express, the only customizations you can do are what's supported by BCM and using your own database or tables is not supported.

    --
    Ken Slovak
    [MVP-Outlook]
    http://www.slovaktech.com
    Author: Professional Programming Outlook 2007
    "eharford" <=?utf-8?B?ZWhhcmZvcmQ=?=> wrote in message news:50cbfadb-b735-4035-97af-7e899f639994...
    Am I right in thinking that Business Contact Manager for Outlook 2010 uses a form of SQL Server Table as its data source? If so can it be configured to use my specific table? With thanks.

    Ken Slovak MVP - Outlook
    Thursday, September 6, 2012 3:50 PM
    Moderator
  • Hi eharford,

    Thanks for posting in the MSDN Forum. I will close this thread, please feel free to unmark which doesn't help you.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, September 12, 2012 6:46 AM
    Moderator