A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I create a task from selected email, then move email to arc



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 18th 08, 10:09 AM posted to microsoft.public.outlook.program_vba
GabrielDubic
external usenet poster
 
Posts: 1
Default How do I create a task from selected email, then move email to arc

Hi all,

I have been stressing over this for three days now and i just can't figure
it out;

I have a shared mailbox attached to my folder list in Outlook 2007 called
Solutions-AU.
I want to be able to select any email from this mailbox's inbox folder then
click a macro button which will create a task, attach the email as an
attachment to this task, as well as fill the task with the email body. This
task needs to go to a sub-task of the above mentioned mailbox, ie August-08.
The same macro needs to them move the email in question to a sibling folder
of the same mailbox (not an inbox subfolder).
I have managed to put together the below macro which only works fine for
items within my own mailbox (GabrielD) but the Task is created in my own Task
folder (can't get it to go into a sub-task) and the email gets moved only in
subfolders of my own Inbox. please please please help!!!

Thank You so much.


Public Sub CreateTaskFromItem()

Dim olTask As Outlook.TaskItem
'Using object rather than MailItem, so that it can handle posts, meeting
requests, etc as well
Set ns = ThisOutlookSession.Session
Dim olItem As Object
Dim olExp As Outlook.Explorer
Dim fldCurrent As Outlook.MAPIFolder
Dim olApp As Outlook.Application
'Set Folder = ns.PickFolder

Set olApp = Outlook.CreateObject("Outlook.Application")
Set olTask = olApp.CreateItem(olTaskItem)
Set olExp = olApp.ActiveExplorer

Dim cntSelection As Integer
cntSelection = olExp.Selection.Count

For I = 1 To cntSelection
Set olItem = olExp.Selection.item(I)
olTask.Attachments.Add olItem
olTask.Body = olItem.Body
olTask.Subject = olItem.SenderName & " - " & olItem.Subject
Next

olTask.Display
'Set the due date for today
olTask.DueDate = Date
'Set the reminder for 4 hours from now
olTask.ReminderSet = True
olTask.ReminderTime = DateAdd("h", 4, Now)

'Saving the task item, so that in case I close it, I won't lose
'the items which were deleted after being attached to the task
'olTask.Save

'Sub MoveSelectedMessagesToFolder()

On Error Resume Next
Dim objFolder As Outlook.MAPIFolder, objInbox As Outlook.MAPIFolder
Dim objNS As Outlook.NameSpace, objItem As Outlook.MailItem
Set objNS = Application.GetNamespace("MAPI")
Set objInbox = objNS.GetDefaultFolder(olFolderInbox)
Set objFolder = objInbox.Folders(".Archive")
'Assume this is a mail folder
If objFolder Is Nothing Then
MsgBox "This folder doesn't exist!", vbOKOnly + vbExclamation,
"INVALID FOLDER"
End If
If Application.ActiveExplorer.Selection.Count = 0 Then
'Require that this procedure be called only when a message is selected
Exit Sub
End If

For Each objItem In Application.ActiveExplorer.Selection
If objFolder.DefaultItemType = olMailItem Then
If objItem.Class = olMail Then
objItem.Move objFolder
End If
End If
Next

Set objItem = Nothing
Set objFolder = Nothing
Set objInbox = Nothing
Set objNS = Nothing
End Sub

Ads
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Email to Task, move task to 'Other Tasks' folder to sync w/Sharepoint mitcham Outlook and VBA 3 August 26th 08 06:55 AM
create a rule to automatially move an email to an archive folderafter replying? [email protected] Outlook - General Queries 1 February 25th 08 11:26 PM
Create task automatically from email Murphybp2 Outlook and VBA 7 January 16th 08 05:48 PM
2 simple macros - create task from email and move email to folder [email protected] Outlook and VBA 5 February 4th 07 10:57 AM
sending selected email as attachment in new email draco Outlook and VBA 2 January 29th 07 02:20 PM


All times are GMT +1. The time now is 04:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.