Excel to set tasks in outlook

**carloskev** · 01-20-2010, 02:49 PM

Hello,

I am having a small problem. I want to use excel to update the tasks in outlook. All I have is a due date (from A2) and a task (from B2) Here is the code I have got so far

Please Login or Register  to view this content.

Which is all working well. However, it doesn't recognize if a task already exists then don't re-enter it. Every time the Macro is ran, it is doing all the tasks over again, instead of just adding the new tasks.

I hope that make sense and im sure its an easy fix but im not a programming wiz. any help would be great as i need this asap

many thanks

**Leith Ross** · 01-20-2010, 08:22 PM

Hello carloskev,

Welcome to the Forum!

I amended your macro to look for the Task using the subject and due date. If it exists then it won't be added again.

Please Login or Register  to view this content.

**carloskev** · 01-21-2010, 04:29 PM

Originally Posted by Leith Ross

Hello carloskev,

Welcome to the Forum!

I amended your macro to look for the Task using the subject and due date. If it exists then it won't be added again.

Please Login or Register  to view this content.

Hi,

I cant thank you enough for sorting that for me. your a STAR

**aavvijit** · 03-22-2011, 07:00 AM

Originally Posted by Leith Ross

Hello carloskev,

Welcome to the Forum!

I amended your macro to look for the Task using the subject and due date. If it exists then it won't be added again.

Please Login or Register  to view this content.

Hi,

Very nice code, but I want a small work around in the above code.....

Is it possible to addd "Start Date" and "Reminder Date" in the above code.

Please Help.