Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-05-2017, 06:36 AM
gmayor's Avatar
gmayor gmayor is offline OL 2016.  "Running rule now" stops too soon. Windows 10 OL 2016.  "Running rule now" stops too soon. Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Use the following macro instead. I have provided alternative lines for messages to someone and from someone. In the case of To, it does not include messages with multiple addresses in 'To ' nor messages where the address is in CC or BCC. For those you would have to loop though the recpients.

Code:
Sub MoveMessages()
Dim olFolder As Outlook.Folder
Dim olItems As Outlook.Items
Dim olItem As Outlook.MailItem
Dim i As Long
Dim strAddress As String
Dim strFolder As String

    strAddress = "someone@somewhere.com"
    strFolder = "Temp" 'subfolder of the default Inbox - must exist
    Set olItems = Session.PickFolder.Items 'Pick the folder containing the messages
    olItems.Sort "[Received]", True
    For i = olItems.Count To 1 Step -1
        Set olItem = olItems(i)
        'If olItem.SenderEmailAddress = strAddress Then 'Messages from someone
        If olItem.To = strAddress Then    'messages to someone
            olItem.Move Session.GetDefaultFolder(olFolderInbox).folders(strFolder)
        End If
        DoEvents
    Next i
    MsgBox "Messages Moved"
lbl_Exit:
    Set olItems = Nothing
    Set olItem = Nothing
    Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
OL 2016.  "Running rule now" stops too soon. Word 2014: WPerfect 6.x full-justification "stops working" dan_1 Word 12 01-24-2017 12:43 PM
OL 2016.  "Running rule now" stops too soon. Erroneously checked "Ignore Rule" while editing BorderDrama Word 1 12-11-2014 01:40 AM
OL 2016.  "Running rule now" stops too soon. Temporarily Removing "Email Delay" Rule tac383 Outlook 2 12-01-2011 01:19 PM
OL 2016.  "Running rule now" stops too soon. How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
Business Contact Manager "assigned to" restriction rule? kossae Outlook 0 05-25-2011 10:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft