View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default send an outlook task to colleagues

thanks i tried but just get "object does not support this property or method"

"Jacob Skaria" wrote:

Try the below

Dim olApp As Outlook.Application
Dim olTsk As TaskItem
Set olApp = New Outlook.Application
Set olTsk = olApp.CreateItem(olTaskItem)


With okTsk
.To = "
.CC = "
.BCC = "
End With

If this post helps click Yes
---------------
Jacob Skaria


"Atishoo" wrote:

thanks for your reply, sadly its no better as an array or as a single address!

"Jacob Skaria" wrote:

Try

", ")

If this post helps click Yes
---------------
Jacob Skaria


"Atishoo" wrote:

I can send a task to my own outlook but cant set another recipient using the
recipient command (it doesnt like it) (or maybe it just doesnt like me) what
code should I be using instead?

Dim olApp As Outlook.Application
Dim olTsk As TaskItem

Set olApp = New Outlook.Application
Set olTsk = olApp.CreateItem(olTaskItem)

With olTsk
.Recipients = ("Salter John")
.Subject = "Update Web Site"
.Status = olTaskInProgress
.Importance = olImportanceHigh
.DueDate = DateValue("06/26/03")
.TotalWork = 40
.ActualWork = 20
.Save
End With

Set olTsk = Nothing
Set olApp = Nothing

End Sub

thanks