Thanks for the help, that is the right track...
Now I have jut two issues left.
First, I need to know how to pull the date out of the cell. When I try I get
an run time error 13 type mismatch.
Second, The other issue is how to get it to loop thruogh rows 4 to 30 and
when there is a value in the correlating "A" column to create a task based
on that rows data.

Thanks again


"**** Kusleika" <dkusleika@gmail.com> wrote in message
news:OVV7ZHsGFHA.2736@TK2MSFTNGP09.phx.gbl...
> Jay
>
> Try here
>
> http://www.*****-clicks.com/excel/olTask.htm
>
> --
> **** Kusleika
> Excel MVP
> Daily Dose of Excel
> www.*****-blog.com
>
> Jay Harris wrote:
>> I want to know if I can create an Outlook task from an Excel macro.
>> If so can someone help me learn to do this?
>>
>> Example of existing workbook:
>>
>> A B C D E
>>
>> 4 Start date Task Name Description Length of task End
>> Date
>>
>> 5 Start date Task Name Description Length of task End
>> Date
>>
>> 6 Start date Task Name Description Length of task End
>> Date
>>
>>
>>
>> I would want to have the macro read the "A" column and, if populated,
>> create an Outlook 2003 task using the data in that row. This should
>> be created for the currently logged in user. I do understand that
>> script wanings may occur without something like Redemption, and that
>> would be OK.
>>
>>
>> Any help would be appreciated,
>>
>> Jay.Harris(at)removethis.cox.com
>
>