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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Tasks in Outlook 2007 with VBA 1
Scan / Update Uncompleted Tasks 6
How to convert email to task on an OPENED EMAIL, pls? 2
Birthdays recreation in Outlook x64 3
Set all Task fields from Subject Line 1
Get Task ID 8
delegate task reminder 0
Editing tasks in outlook 0

Back
Top