In Progress

MS Outlook-to-Excel data translation

I frequently need to export data from Outlook 2007 into Excel 2007 INCLUDING DATE AND TIME INFORMATION. I typically export two types of data from Outlook: (1) A folder of client email items at one time. (2) A filtered list ("view" in Outlook) of client-related Calendar items. You will note that the built-in tools MS provides (even in earlier versions of Office products) do not pull the date and time fields. The work-around has been to import into MS Access from Outlook and then export to Excel. This is cumbersome, error-prone process and inserts unwanted additional spaces and characters at the begining of each Excel field rendering them near useless for data sorting without LOTS of manual editing by hand.

I would like:

Ideally, a button at the top of my Outlook 2007 to start the process. Ask me which folder of email or view/filter of calendar items I want to export and then ask me what file name I want (and where to save). I would like to work with you on what fields I want to see and the format of the output Excel file but this is probably a small piece of the overall project.

Note - my Outlook file/information is nothing special. ANY Outlook content can be used to test this. My Outlook uses Exchange, not a local PST but I understand that does not matter from a programming standpoint.

I expect this to be relatively easy for someone who knows how to program for MS Office apps.

Please let me know if I have left out any information.

Skills: .NET, ASP, C Programming, Visual Basic

See more: outlook export translator, outlook excel translator, outlook excel export translator, microsoft outlook excel translator, data translation work excel, translation programming outlook, export data outlook excel, pull data outlook, getafreelancer outlook export, outlook translation, excel data translation, excel translator outlook, work translation, work of translation, where to start programming, what to program, what is sorting data, what is data sorting, types of sorting in programming, top data, to hand out, test exchange email, sorting of data, programming with data, programming in excel

About the Employer:
( 0 reviews ) California, United States

Project ID: #244962

Awarded to:

mhwse

Hello, shouldn't be too difficult. (normally it should be done in an afternoon - but you never know) Developed all kinds of applications in VB. (Also the extra button should be problem to be added/ did somethin More

$60 USD in 3 days
(0 Reviews)
0.0