Automatic Flag Rule

Tagliaboo · #1 11-18-2016, 07:54 AM

Is it possible to set a rule to flag emails that are received on a day of the week?

I need to review and respond to all emails that come in on Friday and I want to ensure none slip through the cracks

Thanks

gmayor · #2 11-18-2016, 09:34 PM

You can do it with a script associated with a rule to process incoming messages. e.g. the FlagFriday macro below. I have included a macro that will enable you to test on a message in your inbox. Messages sent on Friday are flagged.

Because of Outlook security, you will almost certainly need to self certify the vba code -
http://www.gmayor.com/create_and_employ_a_digital_cert.htm

Code:

Sub TestFlag()
Dim olMsg As MailItem
    On Error Resume Next
    Set olMsg = ActiveExplorer.Selection.Item(1)
    MsgBox Weekday(olMsg.SentOn)
    FlagFriday olMsg
lbl_Exit:
    Exit Sub
End Sub

Sub FlagFriday(Item As Outlook.MailItem)
    If Weekday(Item.SentOn) = 6 Then
        Item.MarkAsTask olMarkToday
        Item.Save
    End If
lbl_Exit:
    Exit Sub
End Sub

Tagliaboo · #3 11-22-2016, 06:15 AM

I am new to scripts in outlook. If possible can you provide simple step by step instructions or a place on the web with easy to follow steps

gmayor · #4 11-22-2016, 07:20 AM

The process is essentially similar to http://www.gmayor.com/installing_macro.htm
Add a module to the VBA editor (ALT+F11 - Insert > Module) and paste the code above in to it.

Tagliaboo · #5 11-22-2016, 07:51 AM

I need to create a macro and paste the entire text you posted or just a section?

gmayor · #6 11-22-2016, 09:53 PM

The macro is the text in the code panel. Actually two macros. You don't have to create anything. Just copy and paste into a new module.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rule to forward email using rule to me@onenote.com	anony1	OneNote	2	02-04-2023 02:39 PM
flag identical words?	21rouge	Word	1	09-21-2013 08:42 AM
Follow-up Flag Behavior	curtis.walker@sgmc.org	Outlook	1	03-06-2013 08:52 AM
How Can I Flag Duplicate Date Entries?	tatihulot	Excel	5	11-16-2012 12:19 AM
Task closing when flag is cleared	pro3carp3	Outlook	1	12-05-2011 10:21 PM