Find Jobs
Hire Freelancers

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

$30-250 USD

Completed
Posted about 9 years ago

$30-250 USD

Paid on delivery
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

About the project

12 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User 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 in 2 days
5.0 (13 reviews)
3.7
3.7
12 freelancers are bidding on average $227 USD for this job
User 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 in 6 days
5.0 (40 reviews)
6.3
6.3
User 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 in 8 days
5.0 (3 reviews)
6.1
6.1
User Avatar
I am an expert in delivering customized scripts and look forward to discuss about the project specs .
$189 USD in 3 days
4.9 (35 reviews)
5.6
5.6
User 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 in 3 days
4.9 (61 reviews)
5.1
5.1
User 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 in 7 days
5.0 (2 reviews)
3.6
3.6
User 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 in 10 days
5.0 (3 reviews)
3.4
3.4
User Avatar
Hello. More 20 years programming experience. Before set final price and time I would like discuss several details. Regards.
$200 USD in 7 days
3.2 (1 review)
2.8
2.8
User 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 in 3 days
0.0 (0 reviews)
0.0
0.0
User 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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
28
Payment method verified
Member since Mar 12, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.