![]() |
VBA for creating Category toolbar in Outlook 2003
Hi,
I know very little about VBA and how to make it work in Outlook. Is there someone who can write what I need to create a category toolbar in Outlook and then tell me how to implement it? Thanks. |
VBA for creating Category toolbar in Outlook 2003
Hi Melody. This isn't something that I can quickly write for you, but it is
possible with a little effort. If you are interested in learning how to write this I'm here to help. You'd need more than Outlook VBA knowledge though. Customizing command bars and menus uses the Office Object Model. Furthermore, Categories are stored in the registry and requires a little more advanced knowledge on how to retrieve that information. -- Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Melody" wrote: Hi, I know very little about VBA and how to make it work in Outlook. Is there someone who can write what I need to create a category toolbar in Outlook and then tell me how to implement it? Thanks. |
VBA for creating Category toolbar in Outlook 2003
Hi Eric,
Thanks for responding. Seems like such a simple request shouldn't be so difficult to accomplish. I'm pretty software/computer savvy so I think I could follow your direction. The only problem is that this is on my work computer and I think they've "locked down" the registry so I can't even look at it. Unless there's another way to see other than regedit. "Eric Legault [MVP - Outlook]" wrote: Hi Melody. This isn't something that I can quickly write for you, but it is possible with a little effort. If you are interested in learning how to write this I'm here to help. You'd need more than Outlook VBA knowledge though. Customizing command bars and menus uses the Office Object Model. Furthermore, Categories are stored in the registry and requires a little more advanced knowledge on how to retrieve that information. -- Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Melody" wrote: Hi, I know very little about VBA and how to make it work in Outlook. Is there someone who can write what I need to create a category toolbar in Outlook and then tell me how to implement it? Thanks. |
VBA for creating Category toolbar in Outlook 2003
If you can use Categories in Outlook, you should be able to access them in
code. Look in regedit for this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Categories\MasterList There is some sample code here that shows how you can retrieve this list: http://www.cdolive.com/cdo5p2.htm (See "Read the master categories list of a user" section) An alternative is to use the Win32API to access the registry, or just Google for "Visual Basic Registry Class" and you'll find some code that you can reuse to work with the registry. There's also some samples here on creating custom command bars and menus: TIP: Fun with Outlook CommandBars: http://www.outlookcode.com/d/tips/commandbarfun.htm Or if you feel like doing some shopping, this add-in might work for you: CategorieZ - Organize your categories the quick and easy way - about: http://www.software-solutions.co.nz/.../alcoabout.asp Let me know if you have any questions. -- Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Melody" wrote: Hi Eric, Thanks for responding. Seems like such a simple request shouldn't be so difficult to accomplish. I'm pretty software/computer savvy so I think I could follow your direction. The only problem is that this is on my work computer and I think they've "locked down" the registry so I can't even look at it. Unless there's another way to see other than regedit. "Eric Legault [MVP - Outlook]" wrote: Hi Melody. This isn't something that I can quickly write for you, but it is possible with a little effort. If you are interested in learning how to write this I'm here to help. You'd need more than Outlook VBA knowledge though. Customizing command bars and menus uses the Office Object Model. Furthermore, Categories are stored in the registry and requires a little more advanced knowledge on how to retrieve that information. -- Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Melody" wrote: Hi, I know very little about VBA and how to make it work in Outlook. Is there someone who can write what I need to create a category toolbar in Outlook and then tell me how to implement it? Thanks. |
VBA for creating Category toolbar in Outlook 2003
Thanks again. I'll look into some of these. Not sure how much I can do as
this is a work pc. I tried regedit to access the registry and I get an access denied type error message. I'll see what I can do anyway. Thanks for the help. "Eric Legault [MVP - Outlook]" wrote: If you can use Categories in Outlook, you should be able to access them in code. Look in regedit for this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Categories\MasterList There is some sample code here that shows how you can retrieve this list: http://www.cdolive.com/cdo5p2.htm (See "Read the master categories list of a user" section) An alternative is to use the Win32API to access the registry, or just Google for "Visual Basic Registry Class" and you'll find some code that you can reuse to work with the registry. There's also some samples here on creating custom command bars and menus: TIP: Fun with Outlook CommandBars: http://www.outlookcode.com/d/tips/commandbarfun.htm Or if you feel like doing some shopping, this add-in might work for you: CategorieZ - Organize your categories the quick and easy way - about: http://www.software-solutions.co.nz/.../alcoabout.asp Let me know if you have any questions. -- Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Melody" wrote: Hi Eric, Thanks for responding. Seems like such a simple request shouldn't be so difficult to accomplish. I'm pretty software/computer savvy so I think I could follow your direction. The only problem is that this is on my work computer and I think they've "locked down" the registry so I can't even look at it. Unless there's another way to see other than regedit. "Eric Legault [MVP - Outlook]" wrote: Hi Melody. This isn't something that I can quickly write for you, but it is possible with a little effort. If you are interested in learning how to write this I'm here to help. You'd need more than Outlook VBA knowledge though. Customizing command bars and menus uses the Office Object Model. Furthermore, Categories are stored in the registry and requires a little more advanced knowledge on how to retrieve that information. -- Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Melody" wrote: Hi, I know very little about VBA and how to make it work in Outlook. Is there someone who can write what I need to create a category toolbar in Outlook and then tell me how to implement it? Thanks. |
VBA for creating Category toolbar in Outlook 2003
Eric, don't forget the much more powerful Category Manager :) http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 -- 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 Tue, 11 Sep 2007 10:38:06 -0700 schrieb Eric Legault [MVP - Outlook]: If you can use Categories in Outlook, you should be able to access them in code. Look in regedit for this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Categories\MasterList There is some sample code here that shows how you can retrieve this list: http://www.cdolive.com/cdo5p2.htm (See "Read the master categories list of a user" section) An alternative is to use the Win32API to access the registry, or just for "Visual Basic Registry Class" and you'll find some code that you can reuse to work with the registry. There's also some samples here on creating custom command bars and menus: TIP: Fun with Outlook CommandBars: http://www.outlookcode.com/d/tips/commandbarfun.htm Or if you feel like doing some shopping, this add-in might work for you: CategorieZ - Organize your categories the quick and easy way - about: http://www.software-solutions.co.nz/.../alcoabout.asp Let me know if you have any questions. |
VBA for creating Category toolbar in Outlook 2003
Thanks Michael,
I didn't want to spend any money on this and probably couldn't use it anyway as this is a work pc. Seems like this is something that should just be a part of Outlook anyway. Oh well. Thanks all for your help. "Michael Bauer [MVP - Outlook]" wrote: Eric, don't forget the much more powerful Category Manager :) http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 -- 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 Tue, 11 Sep 2007 10:38:06 -0700 schrieb Eric Legault [MVP - Outlook]: If you can use Categories in Outlook, you should be able to access them in code. Look in regedit for this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Categories\MasterList There is some sample code here that shows how you can retrieve this list: http://www.cdolive.com/cdo5p2.htm (See "Read the master categories list of a user" section) An alternative is to use the Win32API to access the registry, or just for "Visual Basic Registry Class" and you'll find some code that you can reuse to work with the registry. There's also some samples here on creating custom command bars and menus: TIP: Fun with Outlook CommandBars: http://www.outlookcode.com/d/tips/commandbarfun.htm Or if you feel like doing some shopping, this add-in might work for you: CategorieZ - Organize your categories the quick and easy way - about: http://www.software-solutions.co.nz/.../alcoabout.asp Let me know if you have any questions. |
VBA for creating Category toolbar in Outlook 2003
As we offered in different newsgroups already, we can help you to write the code yourself. But believe me, if that's done you'd wish to have spent the few bucks instead. -- 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 Wed, 12 Sep 2007 05:08:03 -0700 schrieb Melody: Thanks Michael, I didn't want to spend any money on this and probably couldn't use it anyway as this is a work pc. Seems like this is something that should just be a part of Outlook anyway. Oh well. Thanks all for your help. "Michael Bauer [MVP - Outlook]" wrote: Eric, don't forget the much more powerful Category Manager :) http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 -- 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 Tue, 11 Sep 2007 10:38:06 -0700 schrieb Eric Legault [MVP - Outlook]: If you can use Categories in Outlook, you should be able to access them in code. Look in regedit for this key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\O utlook\Categories\MasterList There is some sample code here that shows how you can retrieve this list: http://www.cdolive.com/cdo5p2.htm (See "Read the master categories list of a user" section) An alternative is to use the Win32API to access the registry, or just for "Visual Basic Registry Class" and you'll find some code that you can reuse to work with the registry. There's also some samples here on creating custom command bars and menus: TIP: Fun with Outlook CommandBars: http://www.outlookcode.com/d/tips/commandbarfun.htm Or if you feel like doing some shopping, this add-in might work for you: CategorieZ - Organize your categories the quick and easy way - about: http://www.software-solutions.co.nz/.../alcoabout.asp Let me know if you have any questions. |
All times are GMT +1. The time now is 11:18 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-2006 OutlookBanter.com