![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
Hi:
I have Outlook 2003. I've created a defined custom view for tasks, in table format, that: 1. Is grouped by Start Date 2. Sorted by Number (a user defined field) 3. Then sorted by Reminder time. I frequently, accidentally, (clumsily) click a column heading, which resorts the view. Then I have to go back to Customize current view (which is still grouped by Start Date) hunt for the Number field (under user defined fields) to sort for it, then hunt for Reminder Time (which is under "All task fields"), change the default sort option from descending to ascending, & OK my way out of the dialog box. I'm wondering if anyone has a macro that I could use to perform those tasks. I have no experience in VBA. -- Thank you in advance. Phil |
#2
|
|||
|
|||
![]()
If you have little VBA experience, this may be a daunting task for you.
Every MAPIFolder object has a Views collection, where you can get and update the View.XML property if you know how to edit the schema of the view, as referenced he http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx It's far easier to work with views in code with Outlook 2007. -- Eric Legault - MVP - Outlook MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, WSS 3 Application Development, MOSS 2007 Application Development) Blog: http://blogs.officezealot.com/legault Try Picture Attachments Wizard for Outlook! http://www.collaborativeinnovations.ca "Phil Rabichow" wrote in message ... Hi: I have Outlook 2003. I've created a defined custom view for tasks, in table format, that: 1. Is grouped by Start Date 2. Sorted by Number (a user defined field) 3. Then sorted by Reminder time. I frequently, accidentally, (clumsily) click a column heading, which resorts the view. Then I have to go back to Customize current view (which is still grouped by Start Date) hunt for the Number field (under user defined fields) to sort for it, then hunt for Reminder Time (which is under "All task fields"), change the default sort option from descending to ascending, & OK my way out of the dialog box. I'm wondering if anyone has a macro that I could use to perform those tasks. I have no experience in VBA. -- Thank you in advance. Phil -- Eric Legault - MVP - Outlook MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, WSS 3 Application Development, MOSS 2007 Application Development) Blog: http://blogs.officezealot.com/legault Try Picture Attachments Wizard for Outlook! http://www.collaborativeinnovations.ca |
#3
|
|||
|
|||
![]()
Hi Eric:
Thanks for responding & for the link. You're right, however, it is a daunting task. I think what I need is an example of restoring a particular table view for tasks (not inbox) & then see if I'm bright enough to modify it. Do you know if that exists anywhere. -- I appreciate your time, Phil "Eric Legault [MVP - Outlook]" wrote: If you have little VBA experience, this may be a daunting task for you. Every MAPIFolder object has a Views collection, where you can get and update the View.XML property if you know how to edit the schema of the view, as referenced he http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx It's far easier to work with views in code with Outlook 2007. -- Eric Legault - MVP - Outlook MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, WSS 3 Application Development, MOSS 2007 Application Development) Blog: http://blogs.officezealot.com/legault Try Picture Attachments Wizard for Outlook! http://www.collaborativeinnovations.ca "Phil Rabichow" wrote in message ... Hi: I have Outlook 2003. I've created a defined custom view for tasks, in table format, that: 1. Is grouped by Start Date 2. Sorted by Number (a user defined field) 3. Then sorted by Reminder time. I frequently, accidentally, (clumsily) click a column heading, which resorts the view. Then I have to go back to Customize current view (which is still grouped by Start Date) hunt for the Number field (under user defined fields) to sort for it, then hunt for Reminder Time (which is under "All task fields"), change the default sort option from descending to ascending, & OK my way out of the dialog box. I'm wondering if anyone has a macro that I could use to perform those tasks. I have no experience in VBA. -- Thank you in advance. Phil |
#4
|
|||
|
|||
![]()
Sorry, I don't know of a specific code sample for that.
Eric "Phil Rabichow" wrote in message ... Hi Eric: Thanks for responding & for the link. You're right, however, it is a daunting task. I think what I need is an example of restoring a particular table view for tasks (not inbox) & then see if I'm bright enough to modify it. Do you know if that exists anywhere. -- I appreciate your time, Phil "Eric Legault [MVP - Outlook]" wrote: If you have little VBA experience, this may be a daunting task for you. Every MAPIFolder object has a Views collection, where you can get and update the View.XML property if you know how to edit the schema of the view, as referenced he http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx It's far easier to work with views in code with Outlook 2007. -- Eric Legault - MVP - Outlook MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, WSS 3 Application Development, MOSS 2007 Application Development) Blog: http://blogs.officezealot.com/legault Try Picture Attachments Wizard for Outlook! http://www.collaborativeinnovations.ca "Phil Rabichow" wrote in message ... Hi: I have Outlook 2003. I've created a defined custom view for tasks, in table format, that: 1. Is grouped by Start Date 2. Sorted by Number (a user defined field) 3. Then sorted by Reminder time. I frequently, accidentally, (clumsily) click a column heading, which resorts the view. Then I have to go back to Customize current view (which is still grouped by Start Date) hunt for the Number field (under user defined fields) to sort for it, then hunt for Reminder Time (which is under "All task fields"), change the default sort option from descending to ascending, & OK my way out of the dialog box. I'm wondering if anyone has a macro that I could use to perform those tasks. I have no experience in VBA. -- Thank you in advance. Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
user-defined fields of tasks with VBA | Timber69 | Outlook and VBA | 2 | April 5th 13 12:22 PM |
Macro to switch to calendar/contacts/tasks with folder view in navigation pane | Alex Wenzel | Outlook and VBA | 5 | September 10th 07 07:48 AM |
How to design a custom form that use User defined fields defined on a particular folder (not the default inbox one) | Lucas Campos[_2_] | Outlook - Using Forms | 5 | August 17th 07 06:03 PM |
Tasks - User Defined Columns to Pocket PC Tasks??? | Lovebaby | Outlook - General Queries | 1 | July 23rd 06 09:14 PM |
outlook macro doesn;t run - sub/function not defined | mudshark | Outlook and VBA | 1 | February 6th 06 11:04 PM |