|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
July 10th 07, 10:34 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Deleteing Tasks in Outlook from Excel
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. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 
|
|
#2
July 10th 07, 10:39 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Deleteing Tasks in Outlook from Excel
Use the Namespace.GetDefaultFolder to return the Tasks folder, then use that folder's Items collection.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "J Streger" wrote in message news  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. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003
|
|
#3
July 10th 07, 11:30 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Deleteing Tasks in Outlook from Excel
Thank you. That did the trick!
-- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 User of MS Office 2003 "Sue Mosher [MVP-Outlook]" wrote: Use the Namespace.GetDefaultFolder to return the Tasks folder, then use that folder's Items collection. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "J Streger" wrote in message news 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. -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatically creating tasks/appointments from Excel workbooks | Nick | Outlook - Calandaring | 0 | May 17th 07 04:16 AM |
| Help needed deleteing undeliverable read receipts | T5 | Outlook - General Queries | 1 | December 15th 06 03:21 PM |
| Macro to import Excel data to Tasks | Patrix317 | Outlook and VBA | 2 | May 2nd 06 07:32 PM |
| Is there a way to import TASKS from Excel | mDougMc | Outlook - Calandaring | 2 | April 14th 06 07:43 PM |
| Can tasks be imported and exported to Excel? MS Project? | Mr . . | Outlook - Using Forms | 0 | January 13th 06 10:56 PM |
Hybrid Mode
