Well, I'm sorry:(
I tried the code upside and down without getting any compilation errors, but still the status/priority don't get pasted into the custom status/priority, thus remains invisible in SharePoint.
Thanks for your effort.
/Paul
Diane,
you lost me there....
I assume your idea means that the custom status and custom priority fields should be integrated in the current macro. But how? I'm really on a beginner's level when it comes to this.
"Add the status and priority fields to the view"....?.....they are already...
I think I am getting closer now. Please look in to this code:
Sub ConvertMailtoTask(Item As Outlook.MailItem)
Dim objTask As Outlook.TaskItem
Set objTask = Application.CreateItem(olTaskItem)
Dim strStatus, strPriority
'move this up here just to get it out of the way
Set SPSFolder =...
Well, I found the problem. I had been a little sloppy:) They path was misspelled in the line:
Set SPSFolder = GetFolderPath("SharePoint-lists\Archiving - Archiving registry")
After correction it works again:)
Hi!
The code below converts incoming mail in Outlook to a task and moves the task to a SharePoint-list. So far so good:)
When the task appears in the SharePoint-list it should be given a status (Not Started, Started, Completed) automatically. This is a requirement to make the line visible...
Hi!
My previous post regarding a non working macro has somewhat been resolved. The macro works now and converts incoming mail to tasks and puts them in a dedicated SharePoint-list.
The problem is - which is very odd - that it is only visible to me:(
When my colleagues try to synchronize...
Hi folks!
The following code was put in a self-signed macro two months ago and was working like a charm, but now it doesn't work any more. Any ideas why?
This macro converts incoming mail to a task and then moves them to a SharePoint-list. What happends is that it doesn't do it automatic...
Thanks again. It finally worked like a charm:)
Did a silly mistake though since my system is in swedish where "SharePoint Lists" is "SharePoint-listor". Therefore the path was screwed up and eventhough the macro ran without any faults, the actual move of the task went to a non-existing...
Thanks Diane! It really helps me:rolleyes:
So the GetFolderPath function goes before the code you wrote?
Is it enough to state: Set Items = GetFolderPath("SharePoint Lists\Any_given_subfolder").Items
....is the function included in the system or is it needed to include the whole code -...
This is the Macro:
Sub ConvertMailtoTask(Item As Outlook.MailItem)
Dim objTask As Outlook.TaskItem
Set objTask = Application.CreateItem(olTaskItem)
With objTask
.Subject = Item.Subject
.StartDate = Item.ReceivedTime
.Body = Item.Body
.Save
End With
Set objTask =...
And you can't change these? I guess there must be a way to differentiate incoming from outgoing mail either by setting different servers or possibly by different ports - 110 for POP3 and 25 (or 2525) for SMTP. Otherwise Outlook (or any mail software) will not know how to handle your request...
Hi!
I'm having kind of a challenge.
I'm trying to redirect received e-mails from a shared account in Outlook to a SharePoint task list. By doing so two steps are required:
1. Converting the received e-mail in the shared account's inbox to a task - which unfortunately, as I understand...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.