View Full Version : The Magic, the Mystery of Exporting from Outlook
12-19-2005, 03:11 PM
For anyone who is using Outlook in the Contacts-as-Projects mode discussed in another thread: I gather this is NOT a method to use if one eventually expects to export data for any reason, for example, to Filemaker or Excel.
Am I correct in this assumption, or is there in fact a workable exporting option?
12-23-2005, 07:58 AM
Dk the answer to that, but I am wondering if it is possible to export custom fields from completed tasks, such as the Project field from the Add-In. Based on your question I am guessing the anser is no, but thought I would ask.
Outlook will not export the custom fields of an item (such as a task or contact) using the standard export facility. If you want to export these fields you'll have to write customized Visual Basic Code...
This makes any method of using outlook which requires exporting problematic.
12-27-2005, 05:03 AM
Perhaps some really generous person with VB skills will post the code to export the task data, including all the custom fields:)
12-27-2005, 06:50 AM
Thanks for the information, and I also hope from a gift from VB Santa, since I have no Visual Basic skills...
12-27-2005, 11:05 AM
I found some code samples that are similar to what we want.
I will have to play with them to see...
12-27-2005, 12:00 PM
I found a program that is able to extract custom fields from outlook and put them in a text or csv file. It has a moderate learning curve, but I was able to produce useable output in 30 minutes. Your results may vary.
It has a free trial, fully functional but limited to 25 outlook items. Costs about $20. (I have no affiliation with them.)
I used the following template to put the items in a csv file that I could open in Excel. I included GTD custom fields "Action" and "Project". It handled them fine.
A few quirks...
...The field for notes is called "body" not "notes." This took me a while to figure out.
...It triggers the outlook security warning.
...It has not been updated since 2002 as far as I can tell.