Macro to import Excel data to Tasks

[Patrix317]

I'm looking to create a "simple" macro that will import an Excel spreadsheet
that is pre-formatted with data to my tasks folder.

You may ask why not just keep the tasks in Outlook; however, the projects
are kept for our team in an Access database. I created a simple macro there
that exports the user's tasks to Excel. I can then import the tasks to
Outlook for my personal list.

I did check out the object browser and didn't see any methods there that
sttod out as importing data.

The steps I manually take are:
File/ImportExport
Import from another program
Select Microsoft Excel
Make sure the path and filename are listed correctly in the dialog box
Click on "Do not import duplicates"
Click on Tasks
Click on the checkbox next to my import task (this is there because I've
already mapped the data earlier)
That's about it. The only minor clean up I do is to make sure that the
contact person is filled in. I do this just by opening it and saving it,
then it automatically gets filled in.

Sounds simple enough, and I'm hoping that it is.

Thanks!

Patrick

 

[Sue Mosher [MVP-Outlook]]

You would need to create a new TaskItem, read the data from Excel, set the TaskItem's properties, save it, then repeat for the next Excel data. See http://www.outlookcode.com/d/customimport.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Patrix317]

Thanks, Sue!

You would need to create a new TaskItem, read the data from Excel, set the TaskItem's properties, save it, then repeat for the next Excel data. See http://www.outlookcode.com/d/customimport.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers