Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Need Help creating tasks programmatically

23 views
Skip to first unread message

Rick Williams

unread,
Mar 7, 2000, 3:00:00 AM3/7/00
to
I am trying to create Outlook tasks in a VB app, assign them to various team
members, and have the status of the tasks reflected in my task list.

My code is below. It reads the information from a database and creates the
tasks just fine. But it sends two e-mails for every task, a 'Request' and an
'Update', and if I status a task from a receiver, the results are not
reflected in my Task view. I know it has to do with the various types of
recipient, but I have't been able to pin it down. Can you help?

Set appOut = CreateObject("Outlook.Application")
Adodc1.RecordSource = "Select * from Steps Where ProcessID='" &
txtFields(0).Text & "'"
Adodc1.Refresh
Dim Counter As Integer
Counter = 0
Do While Not Adodc1.Recordset.EOF
Set tsksOut = appOut.CreateItem(olTaskItem)
tsksOut.Recipients.Add (Adodc1.Recordset.Fields("AssignedTo_EMail"))
'recipient's email address
tsksOut.Recipients(1).Type = 2
tsksOut.Recipients.Add (txtFields(3).Text)
tsksOut.Recipients(2).Type = 3
tsksOut.Subject = Adodc1.Recordset.Fields("Step_Name") & " -
Assignment for process " & txtFields(1).Text & " from " & txtFields(3).Text
tsksOut.Body = "Step Name: " & Adodc1.Recordset.Fields("Step_Name")
& Chr(10) & "Description: " & Adodc1.Recordset.Fields("Step_Description") &
Chr(10) & "Instructions: " & Adodc1.Recordset.Fields("Instructions")
tsksOut.DueDate = CDate(txtFields(10).Text)
tsksOut.Owner = txtFields(3).Text ' this text box holds the sender's
e-mail
tsksOut.SchedulePlusPriority = "High"
tsksOut.StatusOnCompletionRecipients = txtFields(11).Text 'this text
box holds the sender's e-mail address
tsksOut.StatusUpdateRecipients = txtFields(11).Text 'this text box
holds the sender's e-mail address
tsksOut.TeamTask = True
tsksOut.Recipients.ResolveAll
tsksOut.Assign
tsksOut.Send
tsksOut.Save
Adodc1.Recordset.MoveNext
Counter = Counter + 1
Loop


I would appreciate any help you could offer. Thank you very much.

Rick Williams
http://www.scramsoftware.vallnet.com


0 new messages