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