Import Outlook tasks into Excel. How do I identify user defined fields ?

A

Art

I created some user defined filelds when setting up tasks in Outlook.
Access to the standard members of the TaskItem Class type is easy
enough but I would like to know which member to use to identify my
created fields.

Following is an extract of my code - I would like to identify and
place a new field I called "Projects" into the next column.

Many thanks in advance.


For Each olTsk In Fldr.Items

ActiveSheet.Cells(i, 1).Value = olTsk.Role
ActiveSheet.Cells(i, 2).Value = olTsk.Subject
ActiveSheet.Cells(i, 3).Value = olTsk.StartDate

i = i + 1

Debug.Print i
Next olTsk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New computer, how do i move outlook 365 ENTIRELY? 0
User-Defined Data TYPE 3
sending outlook tasks to multiple people 0
user defined fields 1
User defined fields 6
How Many User Defined fields in Outlook 2007 1
Extract Country/Region of email sender from outlook message 0
What happened to my user-defined fields? 1

Top