Find Jobs
Hire Freelancers

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

$30-250 USD

Selesai
Dibuat sekitar 9 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim
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 Proyek: 7573644

Tentang proyek

12 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 2 hari
5,0 (13 ulasan)
3,7
3,7
12 freelancer menawar dengan rata-rata $227 USD untuk pekerjaan ini
Avatar Pengguna
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 dalam 6 hari
5,0 (40 ulasan)
6,3
6,3
Avatar Pengguna
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 dalam 8 hari
5,0 (3 ulasan)
6,1
6,1
Avatar Pengguna
I am an expert in delivering customized scripts and look forward to discuss about the project specs .
$189 USD dalam 3 hari
4,9 (35 ulasan)
5,6
5,6
Avatar Pengguna
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 dalam 3 hari
4,9 (61 ulasan)
5,1
5,1
Avatar Pengguna
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 dalam 7 hari
5,0 (2 ulasan)
3,6
3,6
Avatar Pengguna
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 dalam 10 hari
5,0 (3 ulasan)
3,4
3,4
Avatar Pengguna
Hello. More 20 years programming experience. Before set final price and time I would like discuss several details. Regards.
$200 USD dalam 7 hari
3,2 (1 ulasan)
2,8
2,8
Avatar Pengguna
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 dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$155 USD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
Sydney, Australia
5,0
28
Memverifikasi Metode pembayaran
Anggota sejak Mar 12, 2004

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.