Rule Category Conditions Query

Status
Not open for further replies.
J

Jabba1963

Can't seem to get this to work... or get my head round the methods/properties

to get it right...

I've tried using the Object Explorer and even installed OutlookSpy but being

a relative beginner with no formal training in Object Orientated Code I'm

just getting a headache !!

Can anyone help put me on the straight & narrow... it would be much

appreciated - thanks

Dim colRules As Outlook.Rules

Dim oRule As Outlook.Rule

Dim colRuleActions As Outlook.RuleActions

Dim oFromCondition As Outlook.ToOrFromRuleCondition

Dim oCategoryCondition As Outlook.CategoryRuleCondition

Dim oInbox As Outlook.Folder

Dim oMoveTarget As Outlook.Folder

Set oInbox = Application.Session.GetDefaultFolder(olFolderInbox)

Set oMoveTarget = oInbox.Folders(Foldername)

Set colRules = Application.Session.DefaultStore.GetRules()

Set oRule = colRules.Create(Rulename, olRuleReceive)

Set oCategoryCondition = oRule.Conditions.Category

With oCategoryCondition.Categories

> Categories.Add (CategoryName)

End With

oRule.Enabled = False

colRules.Save

All works fine if I comment out the category condition code - rule gets

setup but as soon as I throw the category condition in ie.

Set oCategoryCondition = oRule.Conditions.Category

With oCategoryCondition.Categories

> Categories.Add (CategoryName)

End With

it fails...

Any help appreciated - thx
 
K

Ken Slovak - [MVP - Outlook]

oCategoryCondition.Categories takes/returns a string array, it's not a

collection.

"Jabba1963" <Jabba1963> wrote in message

news:5307CA46-CB9A-4DB8-ABAA-F2BE7AFE664F@microsoft.com...
> Can't seem to get this to work... or get my head round the
> methods/properties
> to get it right...

> I've tried using the Object Explorer and even installed OutlookSpy but
> being
> a relative beginner with no formal training in Object Orientated Code I'm
> just getting a headache !!

> Can anyone help put me on the straight & narrow... it would be much
> appreciated - thanks

> Dim colRules As Outlook.Rules
> Dim oRule As Outlook.Rule
> Dim colRuleActions As Outlook.RuleActions
> Dim oFromCondition As Outlook.ToOrFromRuleCondition
> Dim oCategoryCondition As Outlook.CategoryRuleCondition
> Dim oInbox As Outlook.Folder
> Dim oMoveTarget As Outlook.Folder

> Set oInbox = Application.Session.GetDefaultFolder(olFolderInbox)
> Set oMoveTarget = oInbox.Folders(Foldername)

> Set colRules = Application.Session.DefaultStore.GetRules()

> Set oRule = colRules.Create(Rulename, olRuleReceive)

> Set oCategoryCondition = oRule.Conditions.Category
> With oCategoryCondition.Categories
> .Categories.Add (CategoryName)
> End With

> oRule.Enabled = False

> colRules.Save

> All works fine if I comment out the category condition code - rule gets
> setup but as soon as I throw the category condition in ie.

> Set oCategoryCondition = oRule.Conditions.Category
> With oCategoryCondition.Categories
> .Categories.Add (CategoryName)
> End With

> it fails...

> Any help appreciated - thx
>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
A Can Rule Check Category Contact is assigned? Using Outlook 1
M Outlook 2003 rule to detect a blank category Using Outlook 1
L Rule to select incoming messages by contact category Using Outlook 11
1 Incorrectly Setup a Rule at Domain level to not allow address from outside domain Exchange Server Administration 2
J Transport Rule to detect Keyword question.. Exchange Server Administration 2
T "Words In Recipient's Address" Rule Causes Outlook To Stop Processing Rules Using Outlook 3
R Outlook Autoforward rule do not work for NDR messages Using Outlook 1
R Setup autofoward rule on a particular folder in Outlook Using Outlook 0
N Rule for "on behalf of" - with changing names Using Outlook 2
S Unable to remove rule outlook 2010 Using Outlook 0
O Outlook 2016 This rule will only run when you check your email in Outlook.... Using Outlook 4
Nadine Rule to move attachments with specific name Outlook VBA and Custom Forms 1
N Outlook Email Rule execution through shortcut keys (VBA codes) Using Outlook 1
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
O Rule to move (specific) messages from Sent folder to Specific folder Using Outlook 1
S Adding new Exchange (2016) rule very slow down Microsoft Outlook Exchange Server Administration 0
B Outlook rule run a Script doesn't work Outlook VBA and Custom Forms 1
K VBA BeforeItemMove event create rule to always move to its folder. Outlook VBA and Custom Forms 4
icacream Rule based on sender / wrong sender sent to folder Using Outlook 7
Bri the Tech Guy Run Script rule not running for newly arriving messages Outlook VBA and Custom Forms 25
L Making rule to move email to folder from one O365 domain Using Outlook 1
J Assess content of User Defined Field in Rule Using Outlook 3
S Send email via SMTP - use transport rules to add to senders inbox (then rule to move to sent items Exchange Server Administration 1
A Change order of actions in one (!) rule Outlook VBA and Custom Forms 2
J HELP- Rule to auto strip prepend from external emails Using Outlook 0
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
A rule to flag messages not working Using Outlook 5
Brian Murphy Exchange Online Everything a Transport Rule should do and cannot Exchange Server Administration 1
J Outlook Rules - Changing auto-submit address in multiple rules, according to rule name Outlook VBA and Custom Forms 0
A saving attachement to folder named the same as rule name Outlook VBA and Custom Forms 0
Jennifer Murphy Can I create a Rule with Or'd conditions? Using Outlook 1
A Rules - how to determine if all conditions in rule are true or false Outlook VBA and Custom Forms 5
Vijay Error in rule- Run a script Using Outlook 1
Ascar_CT Rule behavior analysis - any tools available? Using Outlook 0
Liza Creating a rule in outlook to filter messages Using Outlook 0
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
M VBA Rule for removing all body but hyperlink then forwarding Outlook VBA and Custom Forms 9
B custome rule Outlook VBA and Custom Forms 2
Diane Poremsky Mark Sent Items as Read After Copying with a Rule New Slipstick.com Articles 0
Diane Poremsky Run a Script Rule: Send a New Message when a Message Arrives New Slipstick.com Articles 2
T Create Rule For Secondary E-Mail Address In Outlook 2016 Using Outlook 4
B Macro To Create Rule To Export From Certain Folder Email Information in one workbook multiple sheets Outlook VBA and Custom Forms 0
C Rule To Save attachments on receipt of email Outlook VBA and Custom Forms 2
Diane Poremsky Create a Task from an Email using a Rule New Slipstick.com Articles 0
ashcosta2 Auto Reply rule based on speficied time Outlook VBA and Custom Forms 0
M Rule option Using Outlook 2
L Run a Script Rule doesn't work Using Outlook 5
O VBA rule on multiple computers using shared mailbox Outlook VBA and Custom Forms 1
J Transactional emails - mail rule Using Outlook 3
M Question: Is there a rule that will save email in Windows Explorer Outlook VBA and Custom Forms 3
Similar threads


















































Top