|
|
Macro to reset a custom defined view for tasks
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 |
Macro to reset a custom defined view for tasks
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 |
Macro to reset a custom defined view for tasks
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 |
Macro to reset a custom defined view for tasks
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 |
| All times are GMT +1. The time now is 09:03 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-2006 OutlookBanter.com