Is the task list for outlook stored in XML or in something else that's
available to external programming (i.e. not VBA?) We have a SAS program that
extracts monthly production tasks for an individual from a project tracking
system and it would be really nice if we could append those into the outlook
task list.

The alternative would be to program VBA to go get it, but the type of data
structure it is stored in would make that approach problematic.

What exactly is problematic with the data structure? If you can get the SAS
output into a comma-delimited format, you can use Outlook's Import/Export
Wizard, or map the data and manually create the Task items using the Outlook
Object Model from any programming toolset that supports COM.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"kmbarz" wrote:

Is the task list for outlook stored in XML or in something else that's
available to external programming (i.e. not VBA?) We have a SAS program that
extracts monthly production tasks for an individual from a project tracking
system and it would be really nice if we could append those into the outlook
task list.

The alternative would be to program VBA to go get it, but the type of data
structure it is stored in would make that approach problematic.

"Problematic" means that it's in a SAS data set and the only way to allow VBA
to access that is to install drivers that are more problematic than they are
worth. Right now SAS is exporting the csv. I was just hoping to make this
one program or process each person could run instead of multiple steps.

"Eric Legault [MVP - Outlook]" wrote:

What exactly is problematic with the data structure? If you can get the SAS
output into a comma-delimited format, you can use Outlook's Import/Export
Wizard, or map the data and manually create the Task items using the Outlook
Object Model from any programming toolset that supports COM.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"kmbarz" wrote:

Is the task list for outlook stored in XML or in something else that's
available to external programming (i.e. not VBA?) We have a SAS program that
extracts monthly production tasks for an individual from a project tracking
system and it would be really nice if we could append those into the outlook
task list.

The alternative would be to program VBA to go get it, but the type of data
structure it is stored in would make that approach problematic.