Software

Ask something
Discussion Locked

Outlook Email Analysis

0 helpful
3 replies

by carldrinkwater

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a problem that requires me to analyze emails received in a helpdesk mailbox by date and time. I need to chart the date and time received to create a frequency plot. Unfortunately Outlook 2003 doesn't make it easy to export the data to do this type of analysis. Has anyone come across a way to do this?

3 replies

by wayne m.

If you are willing to do some custom programming (C, C++, or VB), you can use the MAPI interface to scroll through the mailbox. A starting reference is to go to MSDN - http://msdn1.microsoft.com/en-us/default.aspx and search for "Simple MAPI".

You will get hits for the various functions, but there will also be a page directing you to a sample program.

by albert widjaja

Hi Carl, you can import your outlook file into MS-Access then you can group it on or do some categorization.

it is as simple as clicking the import from Outlook folder option.

but now i have similar issue, I need to export the help desk email to Oracle DB so that the Internal Support call app. can read from the database to prepare the responding personel.

any idea of how to do it ?

Cheers.

This discussion is closed to new replies.