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

Tags: , , , , , ,

macro to extract subject line and "paste" in advanced search





 
 
Thread Tools Display Modes
  #1  
Old August 2nd 06, 05:21 PM posted to microsoft.public.outlook.program_vba,microsoft.public.outlook.program_addins
stef
external usenet poster
 
Posts: 83
Default 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

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 15th 06, 03:47 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default macro to extract subject line and "paste" in advanced search

The Advanced Find dialog is not accessible programmatically, so you'd have to use some kind of SendKeys kludge. Not something I'd want to depend on.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

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

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

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 21st 06, 12:24 AM posted to microsoft.public.outlook.program_vba
stef
external usenet poster
 
Posts: 83
Default macro to extract subject line and "paste" in advanced search

Sue Mosher [MVP-Outlook] wrote:
The Advanced Find dialog is not accessible programmatically, so you'd have to use some kind of SendKeys kludge. Not something I'd want to depend on.

Sorry Sue, didn't see ur reply.
I guess i really need to upgrade to OL2003 fro the search folders which
will make it a bit easier for me.
OR, use a desktop indexing search that will include OL email messages.

 




Thread Tools
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
Insert "subject" into the "first name" field of contact Luc Outlook - Using Forms 1 July 19th 06 11:31 PM
Outlook Removing "KC:" from subject line when replying or fwding a message readynasgroupbuy@gmail.com Outlook - General Queries 1 July 13th 06 06:01 AM
DO NOT include field "Title" in the name column in "To" search Rob G. Outlook - Using Contacts 7 May 3rd 06 09:47 PM
Macro to prompt for metadata and them place in the subject line Ben Bazian Outlook and VBA 1 April 12th 06 07:19 AM
How do I extract and use the info fields from "form mail" email to Sean Outlook - Using Forms 1 February 1st 06 12:53 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Best Credit Cards - Credit Cards - Cheap Loan - Adverse Credit Remortgage - Online Advertising