Fill Outlook user defined fields from Access 1

[datawise]

I have an app. which automatically creates outlook tasks and fills in the subject and body with appropriate text from the database. I have created two user defined fields in the tasks view in Outlook (Phone1, Phone2), and added them to the simple list view, but I cannot work out how to reference them from the code in Access which creates the new task.

Anyone done this before??

Thanks,

Peter

 

[Mossoft]

I think the user defined properties are in the UserProperties collection. Try something like:

Dim olItem As Outlook.TaskItem

Set olItem = CreateItem(olTaskItem)

olItem.UserProperties.Add "MyProp", olText

olItem.UserProperties(1).Value = "The Value"

With olItem.UserProperties(1)
MsgBox .Name
MsgBox .Value
End With

HTH

M

 

[datawise]

Thanks Mossoft - I hadn't added the userproperty - this works a treat!

Peter