![]() |
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
|
|||
|
|||
![]()
Hello,
using excel VBA I send task planning to my colleagues. Sometimes I need to update the task or to delete it but i'm not able. My code lines a ----- Sub DeleteTaxDayShared() Dim objOL As Outlook.Application Dim objNS As Outlook.Namespace Dim strFind As String Dim objCalFolder As Outlook.MAPIFolder Dim colCalendar As Outlook.Items Dim objAppt As Outlook.TaskItem Dim myRecipient As Outlook.Recipient Set objOL = CreateObject("Outlook.Application") Set objNS = objOL.GetNamespace("MAPI") Set myRecipient = ") myRecipient.Resolve If myRecipient.Resolved Then Set objTaskFolder = objNS.GetSharedDefaultFolder(myRecipient,olFolderT asks) Set colTask = objTaskFolder.Items strFind = "[Subject] = " & Chr(34) & "Tax Day" & Chr(34) Set objTask = colTask.Find(strFind) If Not objTask Is Nothing Then objTask.Delete End If End If Set objOL = Nothing Set objNS = Nothing Set objCalFolder = Nothing Set colCalendar = Nothing End Sub ----- I receive runtime error on: Set objTaskFolder = objNS.GetSharedDefaultFolder(myRecipient, olFolderTasks) Thanks. |
Ads |
#2
|
|||
|
|||
![]()
Do you have permissions to open that Tasks folder? Can you do it using the
UI? -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm wrote in message ps.com... Hello, using excel VBA I send task planning to my colleagues. Sometimes I need to update the task or to delete it but i'm not able. My code lines a ----- Sub DeleteTaxDayShared() Dim objOL As Outlook.Application Dim objNS As Outlook.Namespace Dim strFind As String Dim objCalFolder As Outlook.MAPIFolder Dim colCalendar As Outlook.Items Dim objAppt As Outlook.TaskItem Dim myRecipient As Outlook.Recipient Set objOL = CreateObject("Outlook.Application") Set objNS = objOL.GetNamespace("MAPI") Set myRecipient = ") myRecipient.Resolve If myRecipient.Resolved Then Set objTaskFolder = objNS.GetSharedDefaultFolder(myRecipient,olFolderT asks) Set colTask = objTaskFolder.Items strFind = "[Subject] = " & Chr(34) & "Tax Day" & Chr(34) Set objTask = colTask.Find(strFind) If Not objTask Is Nothing Then objTask.Delete End If End If Set objOL = Nothing Set objNS = Nothing Set objCalFolder = Nothing Set colCalendar = Nothing End Sub ----- I receive runtime error on: Set objTaskFolder = objNS.GetSharedDefaultFolder(myRecipient, olFolderTasks) Thanks. |
#3
|
|||
|
|||
![]()
I don't know.
I don't know Outlook very well, I'm an excel user. I supposed to have the permission due to the fact that I sent the taks to colleagues. the runtime error is -71286782 (fbc04002) that I'm not able to address. If the way I choose is wrong, please give me a suggestion. I'm able to delete or postpone appointment, why I couldn't do the same with tasks? |
#4
|
|||
|
|||
![]()
You need to find out what permissions you have on that other mailbox, I
can't do that for you. The owner of the mailbox needs to look at the delegate permissions that are installed, or your Exchange admins need to do that. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm wrote in message ups.com... I don't know. I don't know Outlook very well, I'm an excel user. I supposed to have the permission due to the fact that I sent the taks to colleagues. the runtime error is -71286782 (fbc04002) that I'm not able to address. If the way I choose is wrong, please give me a suggestion. I'm able to delete or postpone appointment, why I couldn't do the same with tasks? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tasks categories. Unable to modify another user's categories. | Tommy | Outlook - Installation | 0 | August 9th 06 05:43 PM |
how to delete overdue tasks/reminders? | jon | Outlook - General Queries | 1 | August 3rd 06 05:53 PM |
How to delete all calender,tasks,notes,contacts from outlook? | Paul L | Outlook - General Queries | 1 | May 1st 06 06:12 PM |
How do I modify Delete button to also mark item as read? | [email protected] | Outlook and VBA | 1 | April 24th 06 07:14 AM |
User cannot edit or delete tasks | Micheline | Outlook - Installation | 0 | February 15th 06 11:35 PM |