Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   VBA for creating Category toolbar in Outlook 2003 (http://www.outlookbanter.com/outlook-vba/56602-vba-creating-category-toolbar-outlook.html)

melody September 11th 07 01:02 PM

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.

Eric Legault [MVP - Outlook] September 11th 07 05:42 PM

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.


melody September 11th 07 05:58 PM

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.


Eric Legault [MVP - Outlook] September 11th 07 06:38 PM

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.


melody September 11th 07 08:14 PM

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.


Michael Bauer [MVP - Outlook] September 12th 07 05:51 AM

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

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.


melody September 12th 07 01:08 PM

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

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.



Michael Bauer [MVP - Outlook] September 12th 07 03:13 PM

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

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.




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