user-defined fields of tasks with VBA
 

I would like to syncronize an Excel Sheet with my tasks in Outlook using VBA.
My view in Outlook is customized with user-defined fields and I can not
handle these fields with VB. I do not know how to name these user-defined
fields!

user-defined fields of tasks with VBA
 

Use the TaskItem.UserProperties collection. See http://www.outlookcode.com/d/propsyntax.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Timber69" wrote in message ...
I would like to syncronize an Excel Sheet with my tasks in Outlook using VBA.
My view in Outlook is customized with user-defined fields and I can not
handle these fields with VB. I do not know how to name these user-defined
fields!

I have a similar propblem in that my Tasks forms don't think they have any user props at all. If I inspect the count I get 0 for all of them, yet when I look at my custom view of the tasks I can see my custom columns with the data they contain.

The problem seems to have come about when Outlook disconnects each night. When I start it up again the next morning, Tasks are back to using the default form. I run a routine to re-associate the folder and all the Tasks with my custom form again, and this resolves the issue for new Tasks, but the existing ones remain using the default form.

I can't find a way to force them back to using my custom form, and therefore displaying my custom fields on the form.

I was planning on resorting to recreating each one anew, but if I can't access the custom fields, this isn't an option either. It's really frustrating!

Sorry, forgot to mention, this is Outlook 2010