View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bramnizzle@gmail.com is offline
external usenet poster
 
Posts: 36
Default export to outlook task list...

I'm creating a journaling utility for my coworkers. I need a macro
that takes the contents of a cell and exports as a new task in
Outlook. Specifically...

....a subject is entered into A1 (Deliver plans to consultant)
....a due date is entered into B1 (6/20/2007)
....a macro takes the contents of A1 and B1 and creates a Task in
Outlook so that when Outlook Task list is brought up, the task is
there.

I know just about anything is possible with Excel VBA. Can anyone
help me?