RE: Using SQL to access Exchange emails

  • From: "Medeiros, Jose" <jmedeiros@xxxxxxxxxxxxxxx>
  • To: "[ExchangeList]" <exchangelist@xxxxxxxxxxxxx>
  • Date: Wed, 15 Jun 2005 09:03:00 -0700

Hello E, 

I am not sure if I really understand your question, however I am assuming your 
using a helpdesk or support tracking application written in VB? If so what is 
the name of the application? I have installed Clarify Front Office ( Now a 
Nortel company )also written in Visual Basic and it would do just that and it 
could use SMTP to connect to any mail server for sending email notifications 
when a support ticket has been opened, closed or updated, or it could be 
configured to use Mapi for an Exchange server ( Exchange supports SMTP just as 
well ). 

Now if your trying to send SQL alerts to Exchange, SQL has the limitation of 
only using Mapi and does not give you an option to configure it to use a SMTP 
only based server ( Sendmail, Postfix, Qmail etc.. ).

Jose :-)

-----Original Message-----
From: EDS [mailto:e@xxxxxxxxxxxx]
Sent: Wednesday, June 15, 2005 6:00 AM
To: [ExchangeList]
Subject: [exchangelist] Using SQL to access Exchange emails


could someone point me in the right direction, or even develop it for me
and I will pay for it. (if the price is agreeable).

I have a customer SQL DB with a VB front end. From the front end we are
able to send emails but are forced to use exchange to receive emails. The
problem is if one of the customer service reps are out we can only view
notes and emails sent from VB front end.

I dont understand how to connect SQL server2k to exchange, if an email was
received from jsmith@xxxxxxxx and the custmer had that email register in
their recordset, it would be great if It was registered in the customer
recordset hence when we opened jsmith we could see the emails received
double click it and access the email.

Other related posts: