{"id":7655,"date":"2017-08-15T13:59:40","date_gmt":"2017-08-15T17:59:40","guid":{"rendered":"http:\/\/nycphantom.com\/journal\/?p=7655"},"modified":"2017-08-15T14:01:15","modified_gmt":"2017-08-15T18:01:15","slug":"outlook-rules-with-wildcards","status":"publish","type":"post","link":"http:\/\/nycphantom.com\/journal\/?p=7655","title":{"rendered":"To Consider: Outlook Rules with Wildcards"},"content":{"rendered":"

Outlook doesn't like using Wildcards so much, but there's some tips:\u00a0https:\/\/www.slipstick.com\/outlook\/rules\/create-a-rule-with-wildcards\/<\/a><\/p>\n

Outlook doesn't support wildcards in rules, so you can't use use a * or ? character for wildcards. Instead, just specify the string you want to match. For example, if you want to match anything with \"foo\" in the subject text, then any the following would cause the rule to fire:<\/p>\n

Foobar
\nFools
\ntofoo<\/p>\n

Note that the Rules Wizard supports wildcarding for e-mail addresses. By using the \"with specific words in the recipient's address\" and \"with specific words in the sender's address\" conditions, you can set rules for everyone from a particular domain, for example. See\u00a0Creating Rules that Apply to an Entire Domain<\/a>\u00a0for more information.<\/p>\n

However, these address rules do not work for Exchange Server recipients since the Exchange server addresses do not show up in the message header. To apply a rule to addresses within your Exchange organization (or exclude them), use @ as the word in the address (or exclude messages with @ in the address). See\u00a0Creating a Rule to Filter Blank Senders<\/a>\u00a0for more information.<\/p>\n

Display names<\/h2>\n

While a partial word filter won't work in all circumstances, you can use it to filter the display name of senders. For example, this rule will filter messages from Forum Administrator<\/p>\n

\"rule<\/a><\/p>\n

Tip:\u00a0Cancel the Check names dialog<\/a>\u00a0when adding the name to the people or group field:<\/p>\n

\"Create<\/p>\n

Run a Script rule<\/h2>\n

When a rule that looks for partial words isn't working, you can use a run a script rule. This example shows how to filter for the Sender's display name, but it can be used with any Outlook email field.<\/p>\n

Sub CheckSpam(Item As Outlook.MailItem)\r\n  If InStr(LCase(Item.SenderName), \"pfizer\") Then\r\n    Item.Delete\r\n  End If\r\nEnd Sub\r\n<\/pre>\n
Using Wildcards in a Script<\/h3>\n
You can use wildcards in a script, either by using the method below or\u00a0regex<\/a>.<\/p>\n
\n
So on this topic... how about moving all messages that say
\nInvoice AI-SO-11786 from My Company
\nwhere the invoice number changes each time?<\/div>\n<\/blockquote>\n
Assuming AI-SO- is in every invoice and only the numbers change, the next example shows one way to use wildcards in a script. It works with 5 or more digits (or characters) following ai-so-. If the letters are always upper case, you could get away with removing LCASE and using upper case letters in the macro.<\/p>\n
The rule looks for the word\u00a0invoice\u00a0<\/em>in the subject or body and if found, runs this macro to check the subject.<\/p>\n
Sub MoveInvoices(Item As Outlook.MailItem)\r\nDim MoveFolder As Folder\r\nSet MoveFolder = Session.GetDefaultFolder(olFolderInbox)\r\nSet MoveFolder = MoveFolder.Folders(\"Move\")\r\n     If LCase(Item.Subject) Like LCase(\"*ai-so-?????*\") = True Then\r\n      Item.Move MoveFolder\r\n  End If\r\nEnd Sub\r\n<\/pre>\n
See\u00a0Outlook's Rules and Alerts: Run a Script<\/a>\u00a0for more information on using a run a script rule.<\/p>\n","protected":false},"excerpt":{"rendered":"
Outlook doesn't like using Wildcards so much, but there's some tips:\u00a0https:\/\/www.slipstick.com\/outlook\/rules\/create-a-rule-with-wildcards\/ Outlook doesn't support wildcards in rules, so you can't use use a * or ? character for wildcards. Instead, just specify the string you want to match. For example, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7655","post","type-post","status-publish","format-standard","hentry","category-technical"],"_links":{"self":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts\/7655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7655"}],"version-history":[{"count":3,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts\/7655\/revisions"}],"predecessor-version":[{"id":7658,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=\/wp\/v2\/posts\/7655\/revisions\/7658"}],"wp:attachment":[{"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7655"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nycphantom.com\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}