Deleteing Tasks in Outlook from Excel

[J Streger]

I have an Excel a procedure that adds tasks to Outlook for birthday reminders
and service anniversaries. I want a means of deleting tasks from outlook as
well, so in case the list of people changes, I can autodelete the tasks. The
intent is to run this macro on a regular basis, so deleting all tasks put in
by the proceudre and re-applying was my thought. Anyway, adding was easy but
I can only see the reminder collection in outlook. Any help finding that
pesky task collection? Thanks.

 

[Sue Mosher [MVP-Outlook]]

Use the Namespace.GetDefaultFolder to return the Tasks folder, then use that folder's Items collection.

 

[J Streger]

Thank you. That did the trick!

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003