• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

How can I import Microsoft Oullook Master Categories into a Access Data base?

I want to import the full list categories from outlook into an access database for use in sorting, etc.

Ant then if possible add new categories from access to outlook.

Can anybody help with this?
0
rogerdjr
Asked:
rogerdjr
  • 9
  • 5
  • 5
1 Solution
 
TommySzalapskiCommented:
We use an Outlook add-in category manager. It stores the categories in an easy-to-read text file which would be really easy to manipulate in Access.
http://www.codetwo.com/freeware/catman/
0
 
SiddharthRoutCommented:
Can you confirm the Outlook version?

Sid
0
 
rogerdjrAuthor Commented:
outlook 2010 and access 2010
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
SiddharthRoutCommented:
There is one way that I can think of...

I believe Outlook stores the list in the registry, so for OL2010 the key is

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook ~~> Categories key.

Can you confirm that by checking that key?

Sid
0
 
rogerdjrAuthor Commented:
not sure where to find the HKEY_CURRENT_USER path - I did a search and it didn't come-up?
0
 
TommySzalapskiCommented:
2007/2010 do not use the registry to store the category list. They are in the mailbox (or ost file). That's why we use catman. It's free, works nicely, and we also like how you can use it to standardize the colors and categories across your whole organization or group or just individually.
0
 
SiddharthRoutCommented:
CAUTION: Be very careful when you do this.

Click on the start menu ~~> Run
Type "Regedit" without quotes and press enter
The windows registry will open. See snapshot.

Go to the Key I mentioned above and take a screenshot and post it back here. Do Not, I repeat do not alter anything in the registry. Simply post the screenshot and we will take it from there.

Sid
Untitled.jpg
0
 
SiddharthRoutCommented:
Please note that I have outlook 2007 at the moment and that is why you are seeing a '12' in the above screen. In your case it should be 14.

Sid
0
 
SiddharthRoutCommented:
Tommy: Are you sure about that? Because I am not sure.

Sid
0
 
TommySzalapskiCommented:
0
 
SiddharthRoutCommented:
I see. If you scroll down, what are those reg entries for 2007/2010?

Sid
0
 
TommySzalapskiCommented:
That's just for an option to send categories with mail.
0
 
SiddharthRoutCommented:
Ah I see...

Sid
0
 
rogerdjrAuthor Commented:
Screen Shot you requested
screen-shot.jpg
0
 
SiddharthRoutCommented:
rogerdjr: Thanks for the screenshot. I thought you were following our conversation (mine and Tommy's)?

Sid
0
 
rogerdjrAuthor Commented:
I was following, went to the web sites, butv did not find anything that imports categories into access fromoutlook.

Did I miss something?
0
 
SiddharthRoutCommented:
rogerdjr: See Tommy's post in ID: 35002498

I was under the impression that it does store in registry and hence I asked you for the screenshot.

Sid
0
 
TommySzalapskiCommented:
The add-in I referenced (http://www.codetwo.com/freeware/catman) is just a category manager. It stores all the categories (and colors) in a text file. Access reads text files just fine. So I figured you could use that and then you could modify the text file in Access and it would reflect your changes in Outlook.
0
 
rogerdjrAuthor Commented:
Thanks

I see now - works great
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 9
  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now