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

How to write VBA program for outlook to switch between GroupBy options



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 6th 07, 08:16 AM posted to microsoft.public.outlook.program_vba
Little Radish
external usenet poster
 
Posts: 1
Default How to write VBA program for outlook to switch between GroupBy options

Hello, MVPs

Hope my poor English may make you all understand my questions.

I'm using Outlook 2003. In order to have a gmail-like view, I "customize
current view" of the Inbox, and select "Group By" conversation. That really
benefits me a lot to deal with so many mails.

But sometimes "Group By conversation" is a block to sort those mails by
Received field or From field. I have to click by click to select off the
"Group By" option, and select it again after the sort.

I want to write a VBA program to swith between GroupBy options. I knew a few
about VBA in excel, and there is no Macro Recorder in outlook. Would any
MVPs give me some detailed indications, such as which object handle the
options? Related book or webpage containing code fragment is much
apprectiated.

Littel Radish
Welcome to Beijing 2008 Olympics

  #2  
Old September 7th 07, 06:46 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default How to write VBA program for outlook to switch between GroupBy options



You can modify the view with
Application.ActiveExplorer.CurrentFolder.CurrentVi ew.Xml

Easiest is to create manually the needed views and store the xml content
anywhere. then assign one of the stored data to the xml proeprty to switch
the view.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Thu, 6 Sep 2007 15:16:20 +0800 schrieb Little Radish:

Hello, MVPs

Hope my poor English may make you all understand my questions.

I'm using Outlook 2003. In order to have a gmail-like view, I "customize
current view" of the Inbox, and select "Group By" conversation. That

really
benefits me a lot to deal with so many mails.

But sometimes "Group By conversation" is a block to sort those mails by
Received field or From field. I have to click by click to select off the
"Group By" option, and select it again after the sort.

I want to write a VBA program to swith between GroupBy options. I knew a

few
about VBA in excel, and there is no Macro Recorder in outlook. Would any
MVPs give me some detailed indications, such as which object handle the
options? Related book or webpage containing code fragment is much
apprectiated.

Littel Radish
Welcome to Beijing 2008 Olympics

 




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
How do I write my Ms outlook in box mail to a CD Hansi Outlook - General Queries 1 January 29th 07 09:31 AM
How to write a program/macro to send a mail to a groups of e-mail Adi Outlook and VBA 8 December 4th 06 06:20 AM
Switch from Outlook Express Nascar Outlook - Installation 1 November 10th 06 09:29 PM
Trying to write a program that would collect images received as email attachments Vanessa Lee Outlook and VBA 3 February 20th 06 10:59 PM
Outlook 2003 | Tools | Options | Calendar options Sue Mosher [MVP-Outlook] Outlook - General Queries 0 January 18th 06 09:59 PM


All times are GMT +1. The time now is 11:08 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.