已完成

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

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

技能: 微软Outlook, VB.NET, Visual Basic

查看更多: who need an engineer, which company need a engineer, table customer, software developers on call, software developer names, problem summary, need a hardware developer, hrs graphics, engineers on line, engineers in, Engineer needed, developers of visual basic, customer table, html outlook, email to phone call, customer engineer, need a hardware engineer, summary table, require a domain name a company name, outlook visual basic

关于此雇主:
( 28个评论 ) Sydney, Australia

项目ID: #7573644

授予:

Ayan

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 在2天内
(13条评论)
3.7

12 威客就此工作平均出价 $227

maverick44000

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 更多

$400 USD 在6天内
(40条评论)
6.3
esalem

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 更多

$833 USD 在8天内
(3条评论)
6.1
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/ 更多

$250 USD 在3天内
(86条评论)
6.1
srinichal

I am an expert in delivering customized scripts and look forward to discuss about the project specs .

$189 USD 在3天内
(35条评论)
5.6
expertatwork

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 fur 更多

$94 USD 在3天内
(61条评论)
5.1
salih0vicx

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 perso 更多

$198 USD 在7天内
(2条评论)
3.6
pointnetfrance

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 import 更多

$200 USD 在10天内
(3条评论)
3.4
zkutch

Hello. More 20 years programming experience. Before set final price and time I would like discuss several details. Regards.

$200 USD 在7天内
(1条评论)
2.8
ashrafabualia

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 在3天内
(0条评论)
0.0
anooj

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 t 更多

$35 USD 在5天内
(0条评论)
0.0
neerajarya82

A proposal has not yet been provided

$155 USD 在10天内
(0条评论)
0.0