Search for a string

[Dirk]

Hi,

I am trying to create a routine that will allow me to move certain
emails to a particular forlder depending on the subject line. The
problem that I have is that I want only look at emails that have the
subject line formatted as "Ticket no. 9999" and not "Ticket no. not a
number text". I can use the instr function but I was wondering if
there is a better way.

Thanks.

 

[John Goldsmith_Visio_MVP]

Hello Dirk,

You might want to consider Regular Expressions (assuming that the ticket
number might change) which allows you to define a pattern that you want to
match. Check out this link for more information:

http://www.dailydoseofexcel.com/archives/2005/08/13/pattern-matching/

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

 

[Dirk]

Thnk you very much for the information. I got it to work but there is
still a lot that I need to learn.