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