Hey, Scripting Guy! Can I Use Windows PowerShell to Create a New Outlook Inbox Rule?

re: Hey, Scripting Guy! Can I Use Windows PowerShell to Create a New Outlook Inbox Rule?

Ed Wilson — Fri, 14 Sep 2012 13:37:02 GMT

@Sumit Dadhwal this is great. Can you upload it to the script center script repository? gallery.technet.microsoft.com/scriptcenter

re: Hey, Scripting Guy! Can I Use Windows PowerShell to Create a New Outlook Inbox Rule?

Sumit Dadhwal — Fri, 14 Sep 2012 13:23:27 GMT

Script to create a rule for "RSS feed" with "Desktop Alert". I took Dan Jansson's script and modified to fit my needs:

##########################################

# Based on PowerShell 2.0

##########################################

function add_outlook_rule

{

param([string]$RuleName,

[string]$RedirectFolder,

[string[]]$Title)

Add-Type -AssemblyName microsoft.office.interop.outlook

$olFolders = "Microsoft.Office.Interop.Outlook.OlDefaultFolders" -as [type]

$olRuleType = "Microsoft.Office.Interop.Outlook.OlRuleType" -as [type]

$outlook = New-Object -ComObject outlook.application

$namespace = $Outlook.GetNameSpace("MAPI")

$inbox = $namespace.getDefaultFolder($olFolders::olFolderInbox)

$RSSFeeds = $namespace.getDefaultFolder($olFolders::olFolderRSSFeeds)

$rules = $outlook.session.DefaultStore.GetRules()

$rule = $rules.Create($RuleName,$olRuleType::OlRuleReceive)

$d = [System.__ComObject].InvokeMember(

"EntryID",

[System.Reflection.BindingFlags]::GetProperty,

$null,

$RSSFeeds.Folders.Item($RedirectFolder),

$null)

$MoveTarget = $namespace.getFolderFromID($d)

$MoveRuleAction = $rule.Actions.MoveToFolder

[Microsoft.Office.Interop.Outlook._MoveOrCopyRuleAction].InvokeMember(

"Folder",

[System.Reflection.BindingFlags]::SetProperty,

$null,

$MoveRuleAction,

$MoveTarget)

$MoveRuleAction.Enabled = $true

$DisplayAlert = $rule.Actions.DesktopAlert

$DisplayAlert.Enabled = $true

$RSSFeedCondition = $rule.Conditions.FromRssFeed

$RSSFeedCondition.Enabled = $true

$RSSFeedCondition.FromRssFeed = $Title

$rules.Save()

#$olFolder1 = $namespace.Folders.Item(1).Folders.Item("RSS Feeds").Folders.Item($RedirectFolder)

#$olFolder1.AddToFavorites

}

##########################################

# SYNTAX:

##########################################

# add_outlook_rule RULENAME

# MOVETOFOLDER

# Title

##########################################

add_outlook_rule "MyRssFeedRule" "Target Feed Folder" @("Feed TitleWord1","Feed TitleWord2")

re: Hey, Scripting Guy! Can I Use Windows PowerShell to Create a New Outlook Inbox Rule?

Dan Jansson — Tue, 26 Jul 2011 08:41:37 GMT

I also got the ComObject mismatch error and came up with a solution. You can find it here: dandarache.wordpress.com/.../using-powershell-to-create-rules-in-outlook

re: Hey, Scripting Guy! Can I Use Windows PowerShell to Create a New Outlook Inbox Rule?

Kevin — Tue, 10 May 2011 14:09:51 GMT

Great postm, and it works a charm. I am trying to adapt this code to a client side rule on rss fields... for example, I want to create a rule that "from any RSS Feed" "displays _ in the new item alert window" and am having a heck of time getting the syntax right.. any hints?

re: Hey, Scripting Guy! Can I Use Windows PowerShell to Create a New Outlook Inbox Rule?

jcwfbi — Wed, 13 Apr 2011 16:11:25 GMT

How could you use this method to send a message from powershell?

re: Hey, Scripting Guy! Can I Use Windows PowerShell to Create a New Outlook Inbox Rule?

J Orlando — Thu, 11 Nov 2010 14:54:09 GMT

I get the type mismatch error in both Outlook 2007 and 2010.

Have you figured out a solution/workaround to this yet?