| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
send an outlook task to colleagues
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
send an outlook task to colleagues
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
send an outlook task to colleagues
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
send an outlook task to colleagues
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
send an outlook task to colleagues
got it!! code is as follows:
Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.CreateItem(olTaskItem) myItem.Assign Set myDelegate = myItem.Recipients.Add("Jeff Smith") myItem.Subject = "Prepare Agenda For Meeting" myItem.DueDate = #9/20/97# myItem.Send "Atishoo" wrote: 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
send an outlook task to colleagues
got it!! code is as follows:
Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.CreateItem(olTaskItem) myItem.Assign Set myDelegate = myItem.Recipients.Add("Jeff Smith") myItem.Subject = "Prepare Agenda For Meeting" myItem.DueDate = #9/20/97# myItem.Send "Atishoo" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to remove the outlook confirm window when use excel to send email from outlook? | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) | |||
Linear Mode
