PC Review


Reply
Thread Tools Rate Thread

How to define search pattern at end of string?

 
 
Allen_N
Guest
Posts: n/a
 
      21st Jul 2009
I want to search (the subject field) within a folder for strings like
"INC0000000043405", but it's a pain to keep track of all those zeros
(especially with my eyes). Unfortunately, searching for "40435" or "*40435"
fails to find any messages.

Is there a way to search the end of the string? Do I need to write code?

Thanks!
 
Reply With Quote
 
 
 
 
Roady [MVP]
Guest
Posts: n/a
 
      21st Jul 2009
You can use Advanced Find for that.
See http://www.msoutlook.info/question/66

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

http://www.msoutlook.info/
Real World Questions, Real World Answers

-----

"Allen_N" <(E-Mail Removed)> wrote in message
news:A456356B-0B1E-43A7-9459-(E-Mail Removed)...
> I want to search (the subject field) within a folder for strings like
> "INC0000000043405", but it's a pain to keep track of all those zeros
> (especially with my eyes). Unfortunately, searching for "40435" or
> "*40435"
> fails to find any messages.
>
> Is there a way to search the end of the string? Do I need to write code?
>
> Thanks!


 
Reply With Quote
 
Allen_N
Guest
Posts: n/a
 
      22nd Jul 2009
Thanks, Roady.

Now I want to figure out how to invoke the Advanced Find (from VBA) to go
through a column of search patterns in a spreadsheet and move all found mail
items to a specific folder. But, until then, the Advanced Find is a pretty
efficient tool to use manually.

Cheers!


"Roady [MVP]" wrote:

> You can use Advanced Find for that.
> See http://www.msoutlook.info/question/66
>
> --
> Robert Sparnaaij [MVP-Outlook]
> Coauthor, Configuring Microsoft Outlook 2003
> http://www.howto-outlook.com/
> Outlook FAQ, HowTo, Downloads, Add-Ins and more
>
> http://www.msoutlook.info/
> Real World Questions, Real World Answers
>
> -----
>
> "Allen_N" <(E-Mail Removed)> wrote in message
> news:A456356B-0B1E-43A7-9459-(E-Mail Removed)...
> > I want to search (the subject field) within a folder for strings like
> > "INC0000000043405", but it's a pain to keep track of all those zeros
> > (especially with my eyes). Unfortunately, searching for "40435" or
> > "*40435"
> > fails to find any messages.
> >
> > Is there a way to search the end of the string? Do I need to write code?
> >
> > Thanks!

>
>

 
Reply With Quote
 
Roady [MVP]
Guest
Posts: n/a
 
      22nd Jul 2009
You're welcome!

About the VBA solution, you might want to ask the developers down the hall
in outlook.programming_vba for some ideas. Also see
http://www.outlookcode.com.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

http://www.msoutlook.info/
Real World Questions, Real World Answers

-----

"Allen_N" <(E-Mail Removed)> wrote in message
news:A5C0D4A9-2A65-43B8-990C-(E-Mail Removed)...
> Thanks, Roady.
>
> Now I want to figure out how to invoke the Advanced Find (from VBA) to go
> through a column of search patterns in a spreadsheet and move all found
> mail
> items to a specific folder. But, until then, the Advanced Find is a pretty
> efficient tool to use manually.
>
> Cheers!
>
>
> "Roady [MVP]" wrote:
>
>> You can use Advanced Find for that.
>> See http://www.msoutlook.info/question/66
>>
>> --
>> Robert Sparnaaij [MVP-Outlook]
>> Coauthor, Configuring Microsoft Outlook 2003
>> http://www.howto-outlook.com/
>> Outlook FAQ, HowTo, Downloads, Add-Ins and more
>>
>> http://www.msoutlook.info/
>> Real World Questions, Real World Answers
>>
>> -----
>>
>> "Allen_N" <(E-Mail Removed)> wrote in message
>> news:A456356B-0B1E-43A7-9459-(E-Mail Removed)...
>> > I want to search (the subject field) within a folder for strings like
>> > "INC0000000043405", but it's a pain to keep track of all those zeros
>> > (especially with my eyes). Unfortunately, searching for "40435" or
>> > "*40435"
>> > fails to find any messages.
>> >
>> > Is there a way to search the end of the string? Do I need to write
>> > code?
>> >
>> > Thanks!

>>
>>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove the pattern string error in the search box? Van Microsoft Access 0 2nd Mar 2009 05:54 PM
pattern string is invalid Kathy Microsoft Access Getting Started 2 11th Apr 2008 07:32 PM
String Pattern =?Utf-8?B?U3RhdGUgVHJvb3BlcnM=?= Microsoft Access Form Coding 2 11th Apr 2006 01:23 PM
search a string withing a string : find / search hangs itarnak Microsoft Excel Programming 4 24th Oct 2005 03:19 PM
String Pattern Search Ideas Jay B. Harlow [MVP - Outlook] Microsoft VB .NET 6 1st Mar 2004 09:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:00 PM.