Connecting a SQL table to an exchange server

[michael.bollhoefer]

I am trying to mimick the actions of programs such as TRACKIT that will
allow users to send an e-mail to a he******@companyname.com address
and put the information into a SQL table. I am using exchange server
and a SQL database. For example if Joe Blow sends me a message it
would add a new record in the SQL table that automatically created a
work order number, put his name as the requestor, and put the message
body into a text field called ProblemSummary. If anyone has any
suggestions it would help me tremendously.

[michael.bollhoefer]

I have been told that TRACKIT uses a MAPI interface to check the
messages in the inbox. I have been doing some reading on MAPI at MSDN
but still am quite confused about how to go about doing this. Another
update the exchange server is 2003.

mi****************@tybrin.com wrote:

I am trying to mimick the actions of programs such as TRACKIT that will
allow users to send an e-mail to a he******@companyname.com address
and put the information into a SQL table. I am using exchange server
and a SQL database. For example if Joe Blow sends me a message it
would add a new record in the SQL table that automatically created a
work order number, put his name as the requestor, and put the message
body into a text field called ProblemSummary. If anyone has any
suggestions it would help me tremendously.

[J. Clay]

I do something similar, although I don't use VB. I actually created a
program within Outlook using VBA to store messages in SQL. Although this
requires the use of Outlook it is something for you to consider an probably
significantly easier than learning Exchange Events.

I am sure it is doable using Exchange events, but I have not had the time to
try and learn these.

HTH,
J. Clay

<mi****************@tybrin.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

I have been told that TRACKIT uses a MAPI interface to check the
messages in the inbox. I have been doing some reading on MAPI at MSDN
but still am quite confused about how to go about doing this. Another
update the exchange server is 2003.

mi****************@tybrin.com wrote:

I am trying to mimick the actions of programs such as TRACKIT that will
allow users to send an e-mail to a he******@companyname.com address
and put the information into a SQL table. I am using exchange server
and a SQL database. For example if Joe Blow sends me a message it
would add a new record in the SQL table that automatically created a
work order number, put his name as the requestor, and put the message
body into a text field called ProblemSummary. If anyone has any
suggestions it would help me tremendously.

[michael.bollhoefer]

I think that the solution that I am looking for is going to use webdav.
I have been able to export file to an XML document but it seems that
everything is there except the body of the message.

J. Clay wrote:

I do something similar, although I don't use VB. I actually created a
program within Outlook using VBA to store messages in SQL. Although this
requires the use of Outlook it is something for you to consider an probably
significantly easier than learning Exchange Events.

I am sure it is doable using Exchange events, but I have not had the time to
try and learn these.

HTH,
J. Clay

<mi****************@tybrin.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

I have been told that TRACKIT uses a MAPI interface to check the
messages in the inbox. I have been doing some reading on MAPI at MSDN
but still am quite confused about how to go about doing this. Another
update the exchange server is 2003.

mi****************@tybrin.com wrote:

I am trying to mimick the actions of programs such as TRACKIT that will
allow users to send an e-mail to a he******@companyname.com address
and put the information into a SQL table. I am using exchange server
and a SQL database. For example if Joe Blow sends me a message it
would add a new record in the SQL table that automatically created a
work order number, put his name as the requestor, and put the message
body into a text field called ProblemSummary. If anyone has any
suggestions it would help me tremendously.