Update existing rule using VBA

Status
Not open for further replies.
D

darkwolf.mca

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi all,

I'm newbie so please be patient :o

I trying to understand if it exists a way to update an existing rule using VBA.

Within a routine I create a rule like the following:

Set myRules = Application.Session.DefaultStore.GetRules()
Set rl = myRules.Item("Photos")
Set olConditionSubject = rl.Conditions.Subject
With olConditionSubject
.Enabled = True
.Text = Array("White", "Black")
End With
myRules.Save

and that's fine... it works as desired... but how can I add one or more words?

If I create a new routine with

> ..

> ..

With olConditionSubject
.Enabled = True
.Text = Array("Red", "Green")
End With

it replace the one already present... how can I update the rule using VBA so it can filter on all words?

Cheers

Mauro
 
I'm (almost) always patient. :)

I'll check, but I would try reading the rule then updating it - not sure it will work, but I think that is the angle you need to use.

> Text = Array(txtRule, "Red", "Green")
 
Diane Poremsky said:
I'm (almost) always patient. :)

I'll check, but I would try reading the rule then updating it - not sure it will work, but I think that is the angle you need to use.

> Text = Array(txtRule, "Red", "Green")
Click to expand...

Great Diane,

that's could be really the solution I was looking for: read the values from the existing rule in a variable, put the variable in the array with adding words... but:

how can I do it? :(:confused::(

Thx

Mauro
 
Status
Not open for further replies.
< Outlook 2010 disabled macros | Prevent Outlook from resolving incomplete contact when clicking send >
Similar threads
Thread starter Title Forum Replies Date
J Updating existing entry on shared calendar wants to send update from delegate Using Outlook 0
Bachelle Macro to Update Existing Task from New Email Outlook VBA and Custom Forms 3
P Update the existing Contact item Outlook VBA and Custom Forms 1
sjbtax Update Task Custom Field based upon Task Overdue Status Outlook VBA and Custom Forms 8
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 7
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
icacream New password won't update Using Outlook 2
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
O Batch update calendar Using Outlook 3
R Outlook 365 update sets delete from server flag Using Outlook 1
V Update new custom field Outlook VBA and Custom Forms 5
P Outlook 2019 UI changes after 20H2 update Using Outlook 1
D Change Microsoft Account password - what to do to update on all devices Using Outlook 4
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
B Outlook 2016 Retail C2R keeps logging since update? Using Outlook 0
C Not sync folders not found after MS Outlook 365 update Using Outlook 1
W September 2020 - No Default Email Client message after Office Update Using Outlook 1
D.Moore VBA script fail after Office 365 update Using Outlook 8
W April 2020 Office 365 Update - Add-Ons fail after Office 365 Update Using Outlook 6
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
Jennifer Murphy Grant R/W (update) access to a friend Using Outlook 3
L Favorites don't update Using Outlook 1
F Copy and replace not update contact in another pst Using Outlook 0
M Message list font changed after update Using Outlook 2
M Quicken One Step Update Bill Reminders Not Syncing to Outlook Using Outlook 1
O Windows 1803 update : QAT and toolbar changed, language pack gone... Using Outlook 5
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
K Update Appointment category when changed in Excel Using Outlook 3
V Outlook 2003 problem with Windows 10 Creators Update 1709 Using Outlook 0
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
K Update subject based on text in body Outlook VBA and Custom Forms 3
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
M Recent Update Did not Fix Search Problems Using Outlook 7
R Custom Contact Form how to update when loaded. Outlook VBA and Custom Forms 6
C Update Notes for Meeting Attendees Using Outlook 8
A Attendee Update Outlook Meeting Invite Using Outlook 0
Diane Poremsky Outlook Email Security Update Using Outlook 0
S Task Update coming as email and not updating task Using Outlook 3
Diane Poremsky Remove Office 2013 Update Banner Using Outlook 0
B IMAP folders don't update when Outlook 365 opens Using Outlook 0
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
Diane Poremsky Task Request Status Update Address Missing Using Outlook 0
CWM330 Importing from Eudora Update Using Outlook 5
Cameron Piper Automatically update custom forms across multiple computers Outlook VBA and Custom Forms 1
M Update field codes when opening Outlook Template Outlook VBA and Custom Forms 2
I Microsoft Security Update KB3097877 Using Outlook 14
S Outlook 2010: October 2015 Update Using Outlook 0
S Outlook 2013: October 2015 Update Using Outlook 0
Diane Poremsky Update Contacts with a New Company Name and Email Address Using Outlook 0
Diane Poremsky Update Contacts with a New Company Name and Email Address Using Outlook 0

Similar threads

Back
Top