Need help with finding/updating task

Not open for further replies.


Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server

I'm new to Outlook VBA macros and I'm wondering if someone here would be kind enough to help me out.

My Goal: What I'm trying to do is have a macro that looks at the email's subject heading for a keyword, "SR" when I hit Send button. If it exists, prompt me with a message to create a Task (or automatically create it) with the same subject heading as the email's and a due date 4-5 days from now. If a task with the same subject heading already exist, then either delete it and create a new one or update it with the new date.

The Problem I Currently Have: My script some what works. It prompts and creates a new Task based on the email's subject heading. However, it creates a new task for every time I send the email with the same subject heading (i.e. emails of the same thread). So I end up with multiple tasks getting created. I tried implementing different search functions but I don't know what the proper command to us and how to get it to work. If you can show me how to do so or if you can think of a better way to do this, I would be very much appreciated.

Here is what I have so far.

Private Sub MyMailItem_Send(Cancel As Boolean)
    Dim olApp   As Outlook.Application
    Dim olTask  As Outlook.TaskItem
    Dim oFolder As Outlook.MAPIFolder
    Set oFolder = Application.Session.GetDefaultFolder(olFolderTasks)
    Set colItems = oFolder.Items
    Dim strSubject As String
    Dim objSch As Outlook.Search
    If InStr(MyMailItem.Subject, "Mentor Graphics SR") > 0 Then
        If MsgBox("Create A Follow Up Task?", vbYesNo) = vbYes Then
            Set olApp = Application
            strSubject = "Follow Up: " & MyMailItem.To & " : About :" & MyMailItem.Subject
            Dim strFilter As String
            strFilter = "urn:schemas:httpmail:subject = " & strSubject
            Const strScope As String = "'Tasks'"
            Set objSch = olApp.AdvancedSearch(strScope, strFilter)

            If objSch <> Null Then
                MsgBox ("Tasks Found")
                Set olTask = olApp.CreateItem(olTaskItem)
                olTask.Subject = "Follow Up: " & MyMailItem.To & " : About :" & MyMailItem.Subject
                olTask.Body = olTask.Body & MyMailItem.Body & vbCrLf
                olTask.Categories = Replace(MyMailItem.To, ",", "-")
                olTask.DueDate = Date + 4
                olTask.Status = olTaskWaiting
                olTask.Close (olSave)
            End If
        End If
    End If
End Sub

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Calling AdvancedSearch doesn' return the search result, you need to subscribe to the AdvancedSearchComplete event instead.
private sub Application_AdvancedSearchComplete(byval SearchObject as Search)
 'here check Search.Results
end sub

private sub mymailitem_send(cancel as boolean)
  application.advancedsearch scope, filter
end sub
Not open for further replies.
Thread starter Similar threads Forum Replies Date
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using accounts in Outlook 2
C need help setting up outlook first time Using Outlook 1
N Need help syncing contacts to iPhone X Using Outlook 8
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
EaglePI Outlook 2010 need help with rules Using Outlook 0
B Need Help - Willing to pay Outlook VBA and Custom Forms 10
J Need Help with Contacts VBA Outlook VBA and Custom Forms 1
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
Denis Hi everyone!!! Need some help with Excel to Exchange Calendar??PLEASE>>> Using Outlook 1
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
G Need help configuring a PRF for Outlook 2010 and 2013 Using Outlook 0
K Excel Import Option: Need Help Updating Existing Records BCM (Business Contact Manager) 0
K Need help concerning emails linking to BCM. BCM (Business Contact Manager) 0
J Need help with installation of BCM in Outlook2013 BCM (Business Contact Manager) 5
F Outlook 2010 - Need help with a custom field. Using Outlook 3
D Need Help with Script. Keep getting Runtime Error 438 BCM (Business Contact Manager) 4
R Need help getting BCM to work with my Outlook 2014 Using Outlook 4
L Need help getting calendar/contacts/tasks/notes back! Using Outlook 3
R [VBA] complicated(?) outlook events - need help with code Using Outlook 15
P Need help/Gmail accounts show separately/Outlook 2013 Using Outlook 0
J Need Help Extracting Email Content into Excel Specifically the Attachment Name Using Outlook 3
A Need Help with BCM2010 Sharing on outlook 2013 Scenario! BCM (Business Contact Manager) 1
C Need Help with Simple Code Correction Using Outlook 11
W I Need help with and outlook 2010 Using Outlook 2
A My move to MS is not going too well: Need Help !!! Using Outlook 14
M Need help with combo boxes in messages! Using Outlook 10
D Need help understanding which pst-file to use! Using Outlook 0
U Need a help please Outlook 2007 crashing Using Outlook 2
Z Need Help Outlook 2007 inbox and address book view Using Outlook 2
B Need help adding a background color to the compact list items in Month view. Calendar Printing Assistant 1
B Need help adding an image next to the Month Name in the header. Calendar Printing Assistant 1
B Ok - a complicated one - but really need help (auto formatting) Using Outlook 9
B OUTLOOK 2000, Need Help ! Outlook Wishlist 1
P To Use BCM or not...I need help BCM (Business Contact Manager) 1
T Need help making RULE to prepend email SUBJECT Using Outlook 3
V Need help on configuring Outook 2003 Rules and Alerts... Using Outlook 2
A Need Help Urgent !!!- Add Seconde Node To The DAG Exchange Server Administration 12
M Need help w/ Calendar Events not appearing in Outlook 2010 Using Outlook 1
D Need help bulk exporting mailboxes Exchange Server Administration 3
N Need Help with Outlook 2010 Using Outlook 1
G Need help in merging data from multiple .pst data files into one .pst file. Using Outlook 3
F Incoming email titles - i need them back (please help...) Using Outlook 2
B Need help with contact recovery, since trial of Office 2010 has ended. Using Outlook 2
M Need Help on Designing Exchange 2010 Email Solution for 4000 Users Exchange Server Administration 1
S OL2007/XP views will not retain settings. Really need some help here. Using Outlook 2
D Need help repairing Outlook 2010. Using Outlook 2
D Need help with word wrap in Outlook 2010. Using Outlook 5
L Windows Instant Search Indexing not working need help reading Event Log Using Outlook 2
N need help retrieving email from previous Outlook Profile Using Outlook 7
Similar threads