VBA for creating Category toolbar in Outlook 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
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\Outlook\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/aladdins_co/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/
 
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.
 
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 said:
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\Outlook\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/aladdins_co/alcoabout.asp

Let me know if you have any questions.
Click to expand...
Click to expand...
 
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 said:
Eric, don't forget the much more powerful Category Manager :)
Click to expand...
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:
Click to expand...
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\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/aladdins_co/alcoabout.asp

Let me know if you have any questions.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top