Creating an outlook Task from excel

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.

can anyone help me out with this ?

Hi any help appreciated

Issue/area In the task subject
Action in the notes
Responsibility is the assigned to person
Deadline is the due date

Thanks leith

Hi leith can you offer any advice

hi, it doesnt seem to work in the way in which i want it too. Attached is a similar program. if you right mouse click on the the "first day of holiday date" in a particular row and click on "add outlook appointment" it creates a calandar entry.

This is would like this to do, rather than creating multiple task at a time use the same process as the above where you create an indivual task for a row by right clicking on a cell in that row.

awsome thanks works brilliantly

2 last questions

1- How to i get the subject to be made up of the contents of 2 cells ?
2- Is there anyway of Assigning the tasks to the people in a specific cell on the row ?

Please Login or Register  to view this content.