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.