locked
SQL Outlook Integration RRS feed

  • Question

  • Hi,

    I was reading an article for SQL server and Outlook integration in the below link :

    msdn.microsoft.com/en-us/library/office/bb985986.aspx

    There was a link pointing to the sample code. But, it is not available anymore.

    Can someone suggest where I can get, it was an article in the Jan 2002 issue of MSDN magazine.

    Thanks in advance.

    Monday, January 25, 2016 10:35 AM

Answers

  • 1. Read the mail that is sent to a particular id

    2. Parse it to get the query name and the parameters

    https://support.microsoft.com/en-us/kb/313795

    The above would be on what version of Outlook is being used. You can use a Windows service or a  console application to continually query an inbox.

    3. Make a connection to the database to run the query

    4. Return the response via mail

    I don't know what 3 would be about other than to connect to SQL Server and send an email. And you could run some kind of query and turnaround and send a email via SQL Server too.

    https://msdn.microsoft.com/en-us/library/ms190307.aspx

    Tuesday, January 26, 2016 6:21 AM

All replies

  • Probably because those versions of Office and SQL Server are no longer supported.

    What environment are you working in and what are you attempting to accomplish? You didn't mention Visual Basic .NET so perhaps your question needs to be posted to a VBA or Outlook forum?


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Monday, January 25, 2016 1:43 PM
  • Thanks for the suggestion. I will post in those forums too.

    I am trying to achieve the following using Outlook client (Macro runs when a mail arrives) and SQL sever :

    1. Read the mail that is sent to a particular id

    2. Parse it to get the query name and the parameters

    3. Make a connection to the database to run the query

    4. Return the response via mail

    It would be helpful if you can suggest other articles which explain the same.

    Tuesday, January 26, 2016 5:56 AM
  • 1. Read the mail that is sent to a particular id

    2. Parse it to get the query name and the parameters

    https://support.microsoft.com/en-us/kb/313795

    The above would be on what version of Outlook is being used. You can use a Windows service or a  console application to continually query an inbox.

    3. Make a connection to the database to run the query

    4. Return the response via mail

    I don't know what 3 would be about other than to connect to SQL Server and send an email. And you could run some kind of query and turnaround and send a email via SQL Server too.

    https://msdn.microsoft.com/en-us/library/ms190307.aspx

    Tuesday, January 26, 2016 6:21 AM