By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,281 Members | 2,201 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,281 IT Pros & Developers. It's quick & easy.

Connecting a SQL table to an exchange server

P: n/a
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.

Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.


Nov 21 '05 #2

P: n/a
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.

Nov 21 '05 #3

P: n/a
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.


Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.