Outlook Run script on newmail event relating to subject 1

[shavenlunatic]

Hi,

I want to trigger a given action on receipt of an email with "dostuff" in the subject line.

I know its the NewMail event, but I'm just not sure how to pull the subject line into a string variable.

I'm sure it's simple but trying to search for "Outlook" and "Newmail" involved me sifting through a thousand threads about creating new e-mails..

________
clueless

 

[Bong]

You could use the "Rules and Alerts" tool in Outlook and perform "run a script", which is a macro.

_________________
Bob Rashkin

 

[shavenlunatic]

I'd rather not, plus for some reason my modules/subs arent showing in the "Run scripts"

________
clueless

 

[WinblowsME]

Private Sub Application_NewMail()
   Dim ns As Outlook.NameSpace
   Dim inbox As Outlook.MAPIFolder
   Dim subject_line As String
   
   Set ns = GetNamespace("MAPI")
   Set inbox = ns.GetDefaultFolder(olFolderInbox)
   
   subject_line = inbox.Items(1).Subject
   MsgBox subject_line
End Sub

 

[WinblowsME]

If you receive multiple emails at the same time, the above code will not catch every email.

http://support.microsoft.com/kb/292063

 

[shavenlunatic]

aah, thanks mucho I will have a play today

________
clueless