Tasks and Excel

[Guest]

Is it possible to programmatically import and/or create tasks from Excel?

 

[Guest]

Absolutely. Creating a TaskItem is as simple as this (sorry if you already
know this part):

Dim myOlApp As Object, myItem As TaskItem

Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olTaskItem)

Reading the Excel data through automation is out of scope for this forum
though. However, see this page (and the "From Sue's book" section: Listing
24.4 -- Create New Contacts from Data in an Excel Worksheet should be a good
sample to learn from) for some code examples that could help you.

Import and Exporting Data from Custom Microsoft Outlook Forms:
http://www.outlookcode.com/d/customimport.htm