Re: Possible to create rule that uses keywords located in a text f

It's Sue, not Susan.

the lack of a macro recorder
makes it difficult to figure that out.

When in doubt, check the object browser: Press ALt+F11 to open the VBA environment in Outlook, then press F2. Switch from <All Libraries> to Outlook to browse all Outlook objects and their properties, methods, and events. Select any object or member, then press F1 to see its Help topic. Also, there are many, many examples of Outlook code here and on the web. And please ask questions about any code you don't understand.

In the example that you gave is "msg.Subject" the text if the subject line
from the message?

Exactly. msg is the object representing the message. Subject is the property corresponding to the subject.

Would the script-based rule check the text file every time a new message
comes in or would the contents of the file be loaded only when Outlook starts
up?

I'd code it using the latter technique.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"CodeKid" <CodeKid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:8F2A6E1E-E6CC-4EE7-B2AB-7C05A394B0B1@xxxxxxxxxxxxxxxx
Susan,

Thanks very much for the info. One question remains though -- I'm not
familiar with any of the objects in Outlook and the lack of a macro recorder
makes it difficult to figure that out.

In the example that you gave is "msg.Subject" the text if the subject line
from the message?

If so, I think I can have the script reference a text file with the words I
want to search for just by using InStr and a loop.

Would the script-based rule check the text file every time a new message
comes in or would the contents of the file be loaded only when Outlook starts
up?

Thanks again for all of your assistance.




"Sue Mosher [MVP-Outlook]" wrote:

Another approach would be to use a run a script rule action (see example below) to use information read in from a file and process the message with that data. You'd want to read in the file data just once, when Outlook starts.

However, given that there are free antispam tools out there, you might be better off using one of them to do the processing. No doubt it will have optimizations that OUtlook VBA code doesn't.

Here's what a basic "run a script" rule looks like:

Sub RunAScriptRuleRoutine(MyMail As MailItem)
Dim strID As String
Dim olNS As Outlook.NameSpace
Dim msg As Outlook.MailItem

strID = MyMail.EntryID
Set olNS = Application.GetNamespace("MAPI")
Set msg = olNS.GetItemFromID(strID)
' do stuff with msg, e.g.
MsgBox msg.SUbject

Set msg = Nothing
Set olNS = Nothing
End Sub

See http://www.outlookcode.com/d/code/zaphtml.htm#ol2002 for another example.


"CodeKid" <CodeKid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:40E79E86-4A1C-4863-BE9B-57E671117B13@xxxxxxxxxxxxxxxx
In Outlook 2003, rules based on keywords require that each keyword be entered
one at a time. I need to execute a rule based on a lengthly list (not a spam
filter) of words that will need to be changed often. I'd like to do this by
maintaining a text file of the words and have a VBA script (or rule)
reference that file.

Is this possible?

I've written code for Excel but never Outlook. Any guidance/code you can
offer would be greatly appreciated.


-CodeKid



.

Relevant Pages

  • Re: MailItem flags
    ... So, through trial-and-error, it appears that setting FlagIcon to something ... "No Categories (colored by Outlook 2003 Blue flag)". ... item when a flag and/or a reminder is set on it using a MAPI viewer such as ... Msg 1: ...
    (microsoft.public.outlook.program_vba)
  • Re: Is PR_SEARCH_KEY an acceptable substitute for PR_ENTRYID?
    ... Does OutsideIn handle named properties correctly when saving in the MSG ... If you have a contact or appointment saved, does Outlook display it Ok? ... LPDISPATCH pDispItems = folder.GetItems; ... each of which loads the PST and then calls ...
    (microsoft.public.win32.programmer.messaging)
  • Re: Redemption Question - showaddressbook and saveas
    ... OutlookSpy - Outlook, CDO ... like a charm BUT if the user selects Cancel from the address book ... It would only save an empty email .msg file ... Msg = Session .GetDefaultFolder.Items.Add ...
    (microsoft.public.outlook.program_vba)
  • Re: Possible to create rule that uses keywords located in a text f
    ... Sue Mosher, Outlook MVP ... I think I can have the script reference a text file with the words I ... Dim msg As Outlook.MailItem ... Set olNS = Application.GetNamespace ...
    (microsoft.public.outlook.program_vba)
  • Re: scripting message with attachment
    ... Author of Microsoft Outlook 2007 Programming: ... I'd like to script sending a message with an attachment. ... MSG = "Test message" ... NewMail.Body = MSG ...
    (microsoft.public.outlook.program_vba)