RE: Using SQL to access Exchange emails

  • From: "Emanuel de Sousa" <e@xxxxxxxxxxxx>
  • To: "'[ExchangeList]'" <exchangelist@xxxxxxxxxxxxx>
  • Date: Fri, 17 Jun 2005 02:06:25 +1000

Hi Jose,

Love your Surname, I was borne in Madeira Island!!!

Anyway I have a VB front end that we have developed ourselves over the last
5 years its a lending workflow management system. It has the capability of
sending emails with attachments and much more. What it cant do is receive

One of the limitations is that when we receive emails from clients the
emails are sent to specific lending officers which means that if some other
lending officer looks at the customer record set all they see in the DB is
the emails sent. 

I would like to interface exchange so that when an email is received from
eg. John Smith it automatically is attached to John Smith's record set (that
is if the email address received is the same as the email address of John

Emanuel de Sousa
-----Original Message-----
From: Medeiros, Jose [mailto:jmedeiros@xxxxxxxxxxxxxxx] 
Sent: Thursday, 16 June 2005 2:03 AM
To: [ExchangeList]
Subject: [exchangelist] RE: Using SQL to access Exchange emails

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.

List Archives:
Exchange Newsletters:
Exchange FAQ:
Other Internet Software Marketing Sites:
World of Windows Networking:
Leading Network Software Directory:
No.1 ISA Server Resource Site:
Windows Security Resource Site:
Network Security Library:
Windows 2000/NT Fax Solutions:
You are currently subscribed to this Discussion List as:
To unsubscribe visit
Report abuse to listadmin@xxxxxxxxxxxxxx

Other related posts: