Deleteing Tasks in Outlook from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use the Namespace.GetDefaultFolder to return the Tasks folder, then use that folder's Items collection.
 
Thank you. That did the trick!

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

User of MS Office 2003
 
Back
Top