Creating an outlook Task from excel

[jsmity]

hi,

We use action logs a lot in my company and then i transfer my actions into outlook tasks.

Is there a way i can do this via the excel based action log. i tried altering the code used for adding an outlook appointment as per this thread i raised some years back.
http://www.excelforum.com/excel-prog...s-outlook.html

But it doesnt work.

I've attached the action log excel sheet. any help appreciated.