how do i update the due date on a group of tasks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i group tasks into weekly due dates and often don't complete all by the due
date - thus it takes me a long time to roll them forward to the next week -
any ideas?

i have looked into creating a macro but am inexperienced at this - can
programming code for this macro be downloaded?
 
Try the macro below. Make sure that you have the Tasks that you want updated
selected in Outlook, and change the date value in the code to what you want
it to be.

Also, for more resources and help on programming in Outlook, this link is a
great starting point:

Visual Basic and VBA Coding in Microsoft Outlook:
http://www.outlookcode.com/d/vb.htm

Sub UpdateSelectedTasks()
On Error Resume Next

Dim objTask As Outlook.TaskItem
Dim objFolder As Outlook.MAPIFolder

Set objFolder = Application.ActiveExplorer.CurrentFolder
If objFolder.DefaultItemType <> olTaskItem Then
MsgBox "Please select a Task folder!", vbOKOnly + vbExclamation,
"INVALID FOLDER"
GoTo Exitt:
End If

For Each objTask In Application.ActiveExplorer.Selection
objTask.DueDate = #3/18/2005#
objTask.Save
Next

Exitt:
Set objTask = Nothing
Set objFolder = Nothing
End Sub
 
Back
Top