Integrate outlook data with my database data

Question

0.00/5 (No votes)

See more:

Hi guys,

I'm still extremely new to the development world. However I have been tasked to find a way to create an add-on that links to outlook in the form of a ribbon, and then get data from outlook into my SQL database. I have the add-on up and running and it is displaying where it should. However I have been looking for help on how to get the information from outlook into my database, I have looked at multiple sites but all i seem to find is a way to display the inbox or sub-folder contents in a window.

Is there a way to get information from outlook (like who sent the email, or the body content) to save to my database depending on what button I click in my add-on? For example, see if a contact already exists in my database, based on email (thinking of using Linq to query the data) by clicking view.

I hope this makes sense?
Could really just use a nod in the right direction.

Thanks

Posted 5-May-14 23:17pm

Star_Rookie

Add a Solution

Comments

Maciej Los 6-May-14 6:16am

Yes, it is.
Is that what you expected?

Star_Rookie 6-May-14 7:09am

Well yes, it looks perfect. going to try and implement it. Thank you so much for the fast response.

Maciej Los 6-May-14 7:14am

You're welcome ;)
Do not forget to mark my answer as a solution (green button) - formally, to remove question from unanswered list.

Star_Rookie 6-May-14 8:14am

haha thanx, first time I'm asking a question on code project =P. again thank you for the help.

Maciej Los 6-May-14 8:15am

You're very welcome ;)
Call again ;)

Star_Rookie 14-May-14 5:37am

Okay so I am back... I got everything running perfectly for starters and I am truly sorry as it feels like I am making you do all the hard labor, but again I am out of ideas here, when I obtain the email address from the sender and they are already a contact in the address book on outlook, it comes out like this '/O=FIRST ORGANIZATION/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF23SP)/CN=RECIPIENTS/CN=TestE ', with the 'TestE' being the start of the email address, any ideas on how i can solve this? i am looking for the mailitem.SenderEmailAddress... if however the contact does not exist in outlook, the email address pulls through perfectly, any ideas? Thanx again SO much for all the help, I would've been totally lost had it not been for your answers.

Maciej Los 14-May-14 11:46am

It is very interesting issue. I suggest to post this as a question to get the chance for others to post an answer.

Star_Rookie 15-May-14 2:15am

I think I got it figured out, it happens when the contact already exists in outlook, to solve this issue I am going to read the string, if it has abstract characters in it, I will try and get the email address by searching existing outlook contacts using the details I get from the current mail item. If I don't get it right I will post another question =) Thanks

Maciej Los 15-May-14 5:28am

OK, let me know about progress in coding ;)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-05-06T00:45:00

Solution 1

Start here:
Walkthrough: Creating Your First Application-Level Add-in for Outlook[^]
How to: Programmatically Determine the Current Outlook Item[^]

;)

Posted 6-May-14 0:45am

Maciej Los