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

Re-Post: macro to extract subject line and "paste" in advanced search



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 7th 06, 01:45 AM posted to microsoft.public.outlook.program_vba,microsoft.public.outlook.program_addins
stef
external usenet poster
 
Posts: 83
Default Re-Post: macro to extract subject line and "paste" in advanced search

OL 2002 SP3
Win XP HE SP1

Follow-up to: microsoft.public.outlook.program_vba

Can anyone help with this?

Hi,
I need to create some advanced searches that will look into specific
email sub-folders "A" and "C", for example.
I am planning on creating the advanced search, save it locally and put
some icons in a custom toolbar 4 quick access.
Can anyone help me with the 2nd part of this project which would be to
extract the subject line of an email (e.g. "our telephone conversation
of today") and paste it or use it in the Advanced Find search feature
under advanced tab: conversation is (exactly) "our telephone
conversation of today".
I am trying to replicate the "search all related emails" that appears in
yellow on top of email messages headers in preview pane in your inbox
once you have replied to a message ("you replied on 8/2/2006 10:00 AM.
Click here to find all related messages")--a default feature of OL which
unfortunately ONLY searches in the current folder (in my case Inbox),
Inbox, Drafts, Sent Items. I would like to add sub-folders "A" and "C"
to that list or ONLY have sub-folders "A" and "C".
I am open to any other suggestions as to how accomplish this but I was
thinking that since that feature does not seem to be customizable (at
least that's what I am told--but could be subject to registry hack
perhaps?), perhaps a VBA macro could be the only solution.
Thanks for ur expert advice, u geniuses out there!
Ads
  #2  
Old August 7th 06, 02:22 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Re-Post: macro to extract subject line and "paste" in advanced search

You can't access that part of the user interface from code.

First of all, what version of Outlook? If this is Outlook 2003 then just
create a search folder using that search term for the subject and set your
folders to search. That's by far the easiest way and requires no coding.

Otherwise just create your searches as you want and save the search for
re-use.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"stef" stef.bm_at_hotmail.com wrote in message
...
OL 2002 SP3
Win XP HE SP1

Follow-up to: microsoft.public.outlook.program_vba

Can anyone help with this?

Hi,
I need to create some advanced searches that will look into specific
email sub-folders "A" and "C", for example.
I am planning on creating the advanced search, save it locally and put
some icons in a custom toolbar 4 quick access.
Can anyone help me with the 2nd part of this project which would be to
extract the subject line of an email (e.g. "our telephone conversation
of today") and paste it or use it in the Advanced Find search feature
under advanced tab: conversation is (exactly) "our telephone
conversation of today".
I am trying to replicate the "search all related emails" that appears in
yellow on top of email messages headers in preview pane in your inbox
once you have replied to a message ("you replied on 8/2/2006 10:00 AM.
Click here to find all related messages")--a default feature of OL which
unfortunately ONLY searches in the current folder (in my case Inbox),
Inbox, Drafts, Sent Items. I would like to add sub-folders "A" and "C"
to that list or ONLY have sub-folders "A" and "C".
I am open to any other suggestions as to how accomplish this but I was
thinking that since that feature does not seem to be customizable (at
least that's what I am told--but could be subject to registry hack
perhaps?), perhaps a VBA macro could be the only solution.
Thanks for ur expert advice, u geniuses out there!


  #3  
Old August 7th 06, 03:35 PM posted to microsoft.public.outlook.program_vba
stef
external usenet poster
 
Posts: 83
Default Re-Post: macro to extract subject line and "paste" in advancedsearch

Ken Slovak - [MVP - Outlook] wrote:
You can't access that part of the user interface from code.

First of all, what version of Outlook? If this is Outlook 2003 then just
create a search folder using that search term for the subject and set
your folders to search. That's by far the easiest way and requires no
coding.

Otherwise just create your searches as you want and save the search for
re-use.

Ken,
Tx for your reply.
(OL 2002 SP3, Win XP HE)
Unfortunately, I don't have the custom search folders that are available
in OL 2003.
Creating the custom advanced searches is OK but not ideal as, while I
CAN define the search folders that way, I cannot automate the
"Conversation is (exactly)" part, which ideally contains the subject
threads of the emails one is looking for.
Thus, it really isn't any improvement on using the regular built-in
feature of "Click Here to Find Related Messages" and stopping it when it
opens to make the changes in folders searched and then searching again.
Probably the same number of clicks or actions to get what I want....


Incidentally, how do I create a custom button on the toolbar for those
custom searches?
  #4  
Old August 8th 06, 02:10 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Re-Post: macro to extract subject line and "paste" in advanced search

I don't think you can load a saved search that way as far as I know.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"stef" stef.bm_at_hotmail.removethis.com wrote in message
...
Ken Slovak - [MVP - Outlook] wrote:
You can't access that part of the user interface from code.

First of all, what version of Outlook? If this is Outlook 2003 then just
create a search folder using that search term for the subject and set
your folders to search. That's by far the easiest way and requires no
coding.

Otherwise just create your searches as you want and save the search for
re-use.

Ken,
Tx for your reply.
(OL 2002 SP3, Win XP HE)
Unfortunately, I don't have the custom search folders that are available
in OL 2003.
Creating the custom advanced searches is OK but not ideal as, while I CAN
define the search folders that way, I cannot automate the "Conversation is
(exactly)" part, which ideally contains the subject threads of the emails
one is looking for.
Thus, it really isn't any improvement on using the regular built-in
feature of "Click Here to Find Related Messages" and stopping it when it
opens to make the changes in folders searched and then searching again.
Probably the same number of clicks or actions to get what I want....


Incidentally, how do I create a custom button on the toolbar for those
custom searches?


  #5  
Old August 8th 06, 05:02 PM posted to microsoft.public.outlook.program_vba
stef
external usenet poster
 
Posts: 83
Default Re-Post: macro to extract subject line and "paste" in advancedsearch

Ken Slovak - [MVP - Outlook] wrote:
I don't think you can load a saved search that way as far as I know.

I guess this would be a good reason to switch to 2003.... But only for
the "search folders" seems a bit costly.

  #6  
Old August 8th 06, 11:02 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Re-Post: macro to extract subject line and "paste" in advanced search

Outlook 2003 is a lot less buggy than Outlook 2002, at least for coders. And
it has a nicer UI IMHO.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"stef" stef.bm_at_hotmail.removethis.com wrote in message
...
Ken Slovak - [MVP - Outlook] wrote:
I don't think you can load a saved search that way as far as I know.

I guess this would be a good reason to switch to 2003.... But only for
the "search folders" seems a bit costly.


 




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
macro to extract subject line and "paste" in advanced search stef Outlook and VBA 2 August 20th 06 11:24 PM
macro to extract subject line and "paste" in advanced search stef Add-ins for Outlook 0 August 2nd 06 04:21 PM
Insert "subject" into the "first name" field of contact Luc Outlook - Using Forms 1 July 19th 06 10:31 PM
Outlook Removing "KC:" from subject line when replying or fwding a message [email protected] Outlook - General Queries 1 July 13th 06 05:01 AM
DO NOT include field "Title" in the name column in "To" search Rob G. Outlook - Using Contacts 7 May 3rd 06 08:47 PM


All times are GMT +1. The time now is 05:03 AM.


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.