Is it possible to import task information from and Excel Worksheet to
Microsoft Outlook.....so that tasks can be created based on the data in the
worksheet...

Any advice or links appreciated....
--
Scott Lindsay
Excel Development
www.intelexcel.com.au

Try this:

Sub CreateTask()

Dim olApp As Outlook.Application
Dim olTsk As TaskItem

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

With olTsk
.Subject = Range("A1")
.Status = olTaskInProgress
.Importance = olImportanceHigh
.DueDate = Range("A2")
.TotalWork = 40
.ActualWork = 20
.Save
End With

Set olTsk = Nothing
Set olApp = Nothing

End Sub


You may need to set a reference to the Outlook object library.

Hope this helps,
JP

On Oct 7, 8:08 am, scott56hannah
wrote:
Is it possible to import task information from and Excel Worksheet to
Microsoft Outlook.....so that tasks can be created based on the data in the
worksheet...

Any advice or links appreciated....
--
Scott Lindsay
Excel Developmentwww.intelexcel.com.au