Using VBA - Can someone please help on how to send OUtlook tasks to Colleagues.
Sending outlook task is working fine but the reminder is not getting set.
Please help.
Using VBA - Can someone please help on how to send OUtlook tasks to Colleagues.
Sending outlook task is working fine but the reminder is not getting set.
Please help.
I think you may be in the wrong forum as you are in Excel. Anyways, I think what you want is something similar to this:
Somewhere in your code, you should have similar to...
followed by this statement:Please Login or Register to view this content.
Now you want to make sure you add to objOutApp this:Please Login or Register to view this content.
And these two just to be safe:Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you for your reply. Sorry for the inconvenience for posting in wrong forum.
I am new user for this. Actually I am trying to do this in Excel. Can you please suggest on which forum I can post my Query.
When I am trying with below code,
With using .Display property - I am getting "since you are no longer the owner of this task, the task reminder has been turned off."
Without using .Display property - Sending outlook task is working fine but the reminder is not getting set.
Dim objOutApp As New Outlook.Application
Dim objOutTask As Outlook.TaskItem
Set objOutTask = objOutApp.CreateItem(olTaskItem)
With objOutTask
.Display
.Subject = "Task Subject"
.Body = "Task Body"
.DueDate = "Jul 06 2018"
.Recipients.Add ("colleague email address")
.ReminderTime = "Jul 06 2018 11:15 AM"
.ReminderOverrideDefault = True
.ReminderSet = True
.Assign
.Send
End With
objOutTask = Nothing
objOutApp = Nothing
Please do the needful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks