Find Jobs
Hire Freelancers

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

$30-250 USD

Terminado
Publicado hace alrededor de 9 años

$30-250 USD

Pagado a la entrega
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
ID del proyecto: 7573644

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 2 días
5,0 (13 comentarios)
3,7
3,7
12 freelancers están ofertando un promedio de $227 USD por este trabajo
Avatar del usuario
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 en 6 días
5,0 (40 comentarios)
6,3
6,3
Avatar del usuario
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 en 8 días
5,0 (3 comentarios)
6,1
6,1
Avatar del usuario
I am an expert in delivering customized scripts and look forward to discuss about the project specs .
$189 USD en 3 días
4,9 (35 comentarios)
5,6
5,6
Avatar del usuario
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 en 3 días
4,9 (61 comentarios)
5,1
5,1
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
3,6
3,6
Avatar del usuario
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 en 10 días
5,0 (3 comentarios)
3,4
3,4
Avatar del usuario
Hello. More 20 years programming experience. Before set final price and time I would like discuss several details. Regards.
$200 USD en 7 días
3,2 (1 comentario)
2,8
2,8
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$155 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Sydney, Australia
5,0
28
Forma de pago verificada
Miembro desde mar 12, 2004

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.