A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

VBA for creating Category toolbar in Outlook 2003



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 11th 07, 01:02 PM posted to microsoft.public.outlook.program_vba
melody
external usenet poster
 
Posts: 8
Default 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.
Ads
  #2  
Old September 11th 07, 05:42 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default 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.

  #3  
Old September 11th 07, 05:58 PM posted to microsoft.public.outlook.program_vba
melody
external usenet poster
 
Posts: 8
Default 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.

  #4  
Old September 11th 07, 06:38 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default 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.

  #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.

  #6  
Old September 12th 07, 05:51 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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.

  #7  
Old September 12th 07, 01:08 PM posted to microsoft.public.outlook.program_vba
melody
external usenet poster
 
Posts: 8
Default 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.


  #8  
Old September 12th 07, 03:13 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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.


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
creating toolbar button to Mark As Read & Delete Andrea Outlook and VBA 2 June 21st 07 07:26 PM
Customize Toolbar Outlook 2003 Jack Clift Outlook - Installation 3 December 5th 06 05:44 AM
Outlook 2003 contact - standard toolbar Paul Heinisch Add-ins for Outlook 2 August 28th 06 07:00 PM
how can I see a contact's category in outlook 2003? DanBDT Outlook - Using Contacts 1 April 19th 06 10:05 PM
program new toolbar in outlook with VB.NET 2003 Oskar Vaia Add-ins for Outlook 2 March 20th 06 03:34 PM


All times are GMT +1. The time now is 11:42 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-2025 Outlook Banter.
The comments are property of their posters.