Find Jobs
Hire Freelancers

Outlook 2013 addin needed to enter email information into SQL table

$30-250 USD

Inställt
Publicerad nästan nio år sedan

$30-250 USD

Betalning vid leverans
We are a small company providing IT Support. We need an Outlook 2013 application (addin) created that will allow our Helpdesk engineers when viewing an email to click on a button and information contained in the email to be inserted into a table in our SQL 2014 Helpdesk database via OBDC. We had an application like this written but the developer is no longer around and we don’t have any source code. The application looks at the email address in the From settings of the email and compares the domain name of the person sending the email (anything after the @ symbol ie in this example – [login to view URL]) with the domain information contained in a CUSTOMER table in our SQL Helpdesk database. From this lookup the application knows which client the email is coming from. If no match is found in the CUSTOMER table then a pull down list from the CUSTOMERS table should appear allowing the engineer to select the required customer to log the call to. A windows would then appear showing information extracted from two SQL tables (CUSTOMER and STAFF) and information contained in the email being viewed. The window will show the following information Company Name Entered from SQL Customer Table Contact Entered from email address received Phone Received from SQL Customer Table Email Entered from email address received Category A simple pull down list where the engineer can select if the call is Hardware, software, Server, Misc etc Source Entered as “Email” Priority A simple pull down list where the engineer can select Low, medium, High or Critical Date Logged Current Date/Time Problem Summary Entered from the email subject line. We require any information such as RE: or FWD: etc removed from this field Problem Description Entered from information contained in the body of the email. Again we would need HTML, graphics etc removed so information entered into the SQL table is clean text. Assigned To A pull down list connected to an Engineer table which would allow the engineer to select a name to assign the call to. Logged Hrs A text field where the engineer can log time if required. Close Call A check box the engineer can tick if the call is to be entered into the table as closed. All of the above information can be edited from this windows and there should be a Log Helpdesk Call button at the bottom of the window. Once pressed all the information above is entered into a single records in SQL table called HELPDESK. We are able to give the developers all the necessary SQL table and field names that correspond to the fields in the windows above. We require a copy of all source code so that we can modify and compile changes needed down the track. If you need any more information please let me know. Steve
Project ID: 7560209

Om projektet

2 anbud
Distansprojekt
Senaste aktivitet nio år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
2 frilansar lägger i genomsnitt anbud på $75 USD för detta uppdrag
Använd avatar
hey Steve...thanks for the detailed description... We can build an Outlook addin that will be used by your support team. Where do you have the SQL tables - local ? or in a webserver ?...Please reply...we can discuss further...and get this started...thank you !
$94 USD Om 3 dagar
4,9 (57 omdömen)
5,0
5,0
Använd avatar
Hello Steve, I went through your requirement and its crystal clear to me. I have built similar add in for Outlook 2013 of parsing emails when they arrive earlier. So I am confident enough to fulfill your requirement within 3 working days with unlimited support post-delivery. Please let me know when we can discuss further. Thank you.
$55 USD Om 3 dagar
5,0 (11 omdömen)
3,5
3,5

Om kunden

Flagga för AUSTRALIA
Sydney, Australia
5,0
28
Verifierad betalningsmetod
Medlem sedan mars 12, 2004

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.