Find Jobs
Hire Freelancers

Outlook 2013 add-in needed to enter email information into SQL table

$30-250 USD

Slutfört
Publicerad ungefär 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 local 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. So the application would operate as follow. The Engineer who receives and email from a client clicks on a button and the Outlook addin looks at the information contained in the email and does the following. The application looks at the email address in the From settings of the email and then compares the domain name of the person sending the email (anything after the @ symbol with 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 screen 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 Pull down list to 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 the STAFF 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 screen and there should be a Log Helpdesk call button at the bottom of the window. Once pressed all the information above is inserted into a single record in SQL table called HELPDESK. We are able to give the developers all the necessary SQL table and field names 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: 7573644

Om projektet

12 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
Tilldelad till:
Använd avatar
Hello, I have gone through your requirement. I can do this job within 2 days. Please let me know when we can discuss more about this. Thank you.
$90 USD Om 2 dagar
5,0 (13 omdömen)
3,7
3,7
12 frilansar lägger i genomsnitt anbud på $227 USD för detta uppdrag
Använd avatar
Hello Sir. I have understood your project requirement and I can design a professional Outlook 2013 addin using .Net. I have developed several addins for Outlook so far and I can manage yours with ease. I shall need to know the table structure and a little information on functionality of "Log Helpdesk call button", that you have mentioned. Please discuss further details and any concerns that you may have, so we may continue. Regards. Usman
$400 USD Om 6 dagar
5,0 (40 omdömen)
6,3
6,3
Använd avatar
Hello, I am VB, VBA, C#, WPF, Java, PHP, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile and portfolio. I developed many Outlook Add-Ins and macros as you can see in the attachments. I am ready to discuss and doing the project. Regards, Eyad
$833 USD Om 8 dagar
5,0 (3 omdömen)
6,1
6,1
Använd avatar
I am an expert in delivering customized scripts and look forward to discuss about the project specs .
$189 USD Om 3 dagar
4,9 (35 omdömen)
5,6
5,6
Använd avatar
hey Steve...thanks for the detailed information..Is it possible for you to share the current application that you use ? Also, which DB are you using (you told SQL 2014 - what is that)...Please reply..we can discuss further and hopefully get this started soon...thank you...
$94 USD Om 3 dagar
4,9 (61 omdömen)
5,1
5,1
Använd avatar
Hello, From 2007-2011 I worked for USA based company (Houston, TX) called KBR. My job title was HR Supervisor Data Support. Our HR Data Support had to cover two regions and multiple sites. There were around 3k personnel in our AOR (Area of Responsibility). Dealing with emails and various employee forms, reports, personnel movement etc was on daily basis. To help my coworkers I built several Excel/Access/PowerPoint/Word/Outlook tools for various different tasks such as: auto-emailing PDF forms to be checked by each employee and returned back; auto-parsing received emails w/ forms attached and storing data in our local HR Database ... etc. I mentioned above just give you some quick picture about my experience. The last plugin I built an PowerPoint add-in that allow user to insert/embed WebBrowser control (internet xplorer) on the slide and refresh it whenever is needed while the slideshow is running (useful for presentation that display data live from the web) ... Please review my profile - you'll find few projects related to Outlook VSTO. I would like to offer a solution written in VBA. The VBA code remains non-compiled so that user can read it at any time (plain text). That would protect you from any potential missuses by coder. You can read the code yourself and VBA is easy to understand. I would leave certain comments as well for further improvements. Looking forward to hearing from you.
$198 USD Om 7 dagar
5,0 (2 omdömen)
3,6
3,6
Använd avatar
Hi. I am a Senior VB.NET Developer living in Paris, I have read your specifications and i want to realize your application. i have already developed several applications which parse CSV,TXT, or DAT files and imported all their data into an SQL Database. In my Folio you'ill find for example CSV Importer DB Tool i have develop in WPF Full MVVM using Sage API which allowed the user to select a folder, select several CSV files. and click to load them and calulate and preformat them before inserting into the SQlServer database. That's why if you choose my bid i can create for you the plugin. I invite you to see in my folio the kind of application i have realize for an idea. You can contact me for any questions else. Kind regards
$200 USD Om 10 dagar
5,0 (3 omdömen)
3,4
3,4
Använd avatar
Hello. More 20 years programming experience. Before set final price and time I would like discuss several details. Regards.
$200 USD Om 7 dagar
3,2 (1 omdöme)
2,8
2,8
Använd avatar
Will add all requirements. and will provide you the source code for any future updates. this will be done using vb. it is doable
$80 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I have created a sample macro on this and it is working fine, I can showcase this work before we start. I have more than 4 years of experience in VB programming field and Since I am new in this site I like to do this task for a very less price. Please consider my bid.
$35 USD Om 5 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
A proposal has not yet been provided
$155 USD Om 10 dagar
0,0 (0 omdömen)
0,0
0,0

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.