View Single Post
  #5  
Old September 11th 07, 08:14 PM posted to microsoft.public.outlook.program_vba
melody
external usenet poster
 
Posts: 8
Default 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.

Ads