A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Find and select mail in ActiveExplorer



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 28th 06, 11:42 PM posted to microsoft.public.outlook.program_vba
Gvaram
external usenet poster
 
Posts: 14
Default Find and select mail in ActiveExplorer

Please somebody help me to find last UnRead mail with text like "Test*" in
Subject and select it. I Found last UnRead mail by

Set objMail =
Application.GetNamespace("MAPI").GetDefaultFolder( olFolderInbox).Items.Find("([UnRead] = True)")

but could not do anything else. As I see "Like" operator there is not
functioning.
And after finding this massage, how to select it in ActiveExplorer.
  #2  
Old September 29th 06, 06:38 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Find and select mail in ActiveExplorer

Am Thu, 28 Sep 2006 15:42:01 -0700 schrieb Gvaram:

You´re right, the LIKE operator doesn´t work in that case. Instead you need
to iterate through all the items and check for the subject. Before that you
could sort the collection by Items.Sort for the received date and restrict
it for unread items.

But there´s no way to select the result.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Please somebody help me to find last UnRead mail with text like "Test*" in
Subject and select it. I Found last UnRead mail by

Set objMail =

Application.GetNamespace("MAPI").GetDefaultFolder( olFolderInbox).Items.Find("([UnRead]
= True)")

but could not do anything else. As I see "Like" operator there is not
functioning.
And after finding this massage, how to select it in ActiveExplorer.

  #3  
Old October 1st 06, 07:19 PM posted to microsoft.public.outlook.program_vba
Gvaram
external usenet poster
 
Posts: 14
Default Find and select mail in ActiveExplorer

Your answer forced me to find another way to solve problem - and I found it.
I'm getting EntryID of MeilItem, so I can do many things with this mail
massage ...

Thank you Michael


"Michael Bauer [MVP - Outlook]" wrote:

Am Thu, 28 Sep 2006 15:42:01 -0700 schrieb Gvaram:

You´re right, the LIKE operator doesn´t work in that case. Instead you need
to iterate through all the items and check for the subject. Before that you
could sort the collection by Items.Sort for the received date and restrict
it for unread items.

But there´s no way to select the result.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Please somebody help me to find last UnRead mail with text like "Test*" in
Subject and select it. I Found last UnRead mail by

Set objMail =

Application.GetNamespace("MAPI").GetDefaultFolder( olFolderInbox).Items.Find("([UnRead]
= True)")

but could not do anything else. As I see "Like" operator there is not
functioning.
And after finding this massage, how to select it in ActiveExplorer.


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cancelling Outlook.Application.ActiveExplorer.Close event? Nathan Add-ins for Outlook 1 September 8th 06 07:14 PM
Sort/Find by "Display Name" on Select Names screen in Address Bk Bob Schorr Outlook - Using Contacts 0 June 28th 06 10:31 PM
Browse and select mail messages? Fox via OfficeKB.com Outlook and VBA 1 June 22nd 06 05:50 AM
I cant e-mail using this e-mail says cant find server [email protected] Outlook - General Queries 3 June 13th 06 10:20 PM
Can't select "show this folder as an e-mail address book" Michael Blaut Outlook - Using Contacts 5 February 12th 06 03:22 PM


All times are GMT +1. The time now is 12:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.