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

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top