RE: Using SQL to access Exchange emails

  • From: "John Tolmachoff \(Lists\)" <johnlist@xxxxxxxxxxxxxxxxxxx>
  • To: "'[ExchangeList]'" <exchangelist@xxxxxxxxxxxxx>
  • Date: Thu, 16 Jun 2005 09:30:44 -0700

Well, in the next proposed version of Exchange, you will have a better
chance of doing that as it will be SQL based instead of Jet based. Or maybe
that is the following version.

John T
eServices For You


> -----Original Message-----
> From: Emanuel de Sousa [mailto:e@xxxxxxxxxxxx]
> Sent: Thursday, June 16, 2005 9:06 AM
> To: [ExchangeList]
> Subject: [exchangelist] RE: Using SQL to access Exchange emails
> 
> http://www.MSExchange.org/
> 
> 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
> emails.
> 
> 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
> Smith)
> 
> 
> 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
> 
> http://www.MSExchange.org/
> 
> 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
> 
> 
> http://www.MSExchange.org/
> 
> Hi,
> 
> 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: http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
> Exchange Newsletters: http://www.msexchange.org/pages/newsletter.asp
> Exchange FAQ: http://www.msexchange.org/pages/larticle.asp?type=FAQ
> ------------------------------------------------------
> Other Internet Software Marketing Sites:
> World of Windows Networking: http://www.windowsnetworking.com
> Leading Network Software Directory: http://www.serverfiles.com
> No.1 ISA Server Resource Site: http://www.isaserver.org
> Windows Security Resource Site: http://www.windowsecurity.com/
> Network Security Library: http://www.secinf.net/
> Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
> ------------------------------------------------------
> You are currently subscribed to this MSEXchange.org Discussion List as:
> e@xxxxxxxxxxxx
> To unsubscribe visit
> http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
> Report abuse to listadmin@xxxxxxxxxxxxxx
> 
> 
> 
> 
> ------------------------------------------------------
> List Archives: http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
> Exchange Newsletters: http://www.msexchange.org/pages/newsletter.asp
> Exchange FAQ: http://www.msexchange.org/pages/larticle.asp?type=FAQ
> ------------------------------------------------------
> Other Internet Software Marketing Sites:
> World of Windows Networking: http://www.windowsnetworking.com
> Leading Network Software Directory: http://www.serverfiles.com
> No.1 ISA Server Resource Site: http://www.isaserver.org
> Windows Security Resource Site: http://www.windowsecurity.com/
> Network Security Library: http://www.secinf.net/
> Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
> ------------------------------------------------------
> You are currently subscribed to this MSEXchange.org Discussion List as:
> johnlist@xxxxxxxxxxxxxxxxxxx
> To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=exchangelist
> Report abuse to listadmin@xxxxxxxxxxxxxx



Other related posts: