• Subject: RE: Scanning E-mail for Certain words & changing the background
  • Author: Rhutch
  • Date: 27 May 2010
  • References: 1 2 3
I was able to get some code that scans a Word document highlights a word the
user enters but it won't work on Outlook.

Sub FindRepetitiveWords()
'
' Find Repetitive Words Macro
' Macro recorded 11/6/2003 by Monica Burns

'//Get Info from User

'//Place information in variable sUserString and Insert into document

Dim sUserString As String

sUserString = InputBox("Please Enter The Word to Search For", "Word
Searching For")

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
Selection.Find.Replacement.Highlight = True

With Selection.Find
.Text = sUserString
.Replacement.Text = sUserString
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With

Selection.Find.Execute Replace:=wdReplaceAll

End Sub

If anybody can point me to something that would show how to conver t it
Outlook, I would appreciated it.

thanks,
rhutch

"Rhutch" wrote:

> Sue:
>
> I tried several times to log into the Community newsgroup but couldn't seem
> to get the web page to display after attempting to log-on. I finally get it
> to respond. I have read your response and hopefully can provide the
> information you requested. I am using version 2003 of Outlook at work. The
> intent, I think, is to open an e-mail and run a macro that looks for certain
> words. Once it finds an occurrence of one of the words, it highlights it,
> and changes the background to a different color, such as yellow, then
> continues to the end of the e-mail. The person who asked me to do this for
> him apparently gets several e-mails a day, 30 or so pages long and currently
> has to go through them manually to find the designated words.
>
> Hope you get this.
> Thanks very much for responding,
> --
> rhutch
>
>
> "Sue Mosher [MVP]" wrote:
>
> > In what version of Outlook? Highlight those words in an open message? In the
> > reading pane?
> > --
> > Sue Mosher, Outlook MVP
> > Author of Microsoft Outlook 2007 Programming:
> > Jumpstart for Power Users and Administrators
> > http://www.outlookcode.com/article.aspx?id=54
> >
> >
> >
> > "Rhutch" wrote:
> >
> > > Hello,
> > > I have been asked to write a macro for Outlook that will scan an e-mail for
> > > select words such as Voluntary, Surrender, etc. and then change the
> > > background (highlight) those words found in an e-mail. I have used VBA in
> > > Excel and Access but not in Outlook.
> > >
> > > I looked through all 43 pages on the site and could not find a post to help.
> > > Probably looked right past several.
> > >
> > > Anyway, any help would be appreciated.
> > >
> > > thanks,
> > > --
> > > rhutch
21 May 2010Scanning E-mail for Certain words & changing the background.Rhutch
21 May 2010\ RE: Scanning E-mail for Certain words & changing the background.Sue Mosher [MVP]
24 May 2010   \ RE: Scanning E-mail for Certain words & changing the background.Rhutch
27 May 2010      \ RE: Scanning E-mail for Certain words & changing the background.Rhutch
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)