bulk add categories / with fixed colours / select multiple categories on a not

Not open for further replies.


New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hi I have a couple of questions.

I've been looking through google, slipstick and other locations be so far I haven't even found out if it's possible or not so I'm hoping you can help. I am migrating categories from archived emails in a public folder from OL2003, they are not in a master list.

1. I have 3000 categories of 8 digits, 600 of 6 digits and and 200 of 4 digits. It is easy enough for me to get the lists together in a comma-separated file however the category field in contact area only allows for 252 characters. Is there another way to get these added as I can only do 27 at a time?

2. I want to set colours so that all the 3000 are blue, all the 600 red and all the 200 green. Without going into each one individually and changing the colour how is this possible?

3. Once created, I need to share the master list with other people. I can add the categories to a note, put it in the public area, they can pull it out and update their cats. Simple...however... as you can see I have a lot of categories. How can I select all cats to add to a note/message/contact/anything? At the moment I can only see that I have to select each one individually.


Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: bulk add categories / with fixed colours / select multiple categories on a

Have you seen Create a list of color categories and merge or restore the list using VBA - Slipstick Systems

That VBA uses a format of AddCategory "category", 17, 0 - it should be fairly easily to create this list for each category using Excel - the 17 is a color, so it would be the same for each group (but I forget what color 17 represents. :))

That said, I thought Outlook had a limit on the # of categories - and that it was well under 3600.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
F Auto changing email subject line in bulk Using Outlook 2
D Contact Group - Adding Bulk Addresses Using Outlook 2
F Outlook 2016 bulk email from access Outlook VBA and Custom Forms 3
J 14 Steps To Building Your Bulk Emails So They Get Noticed Using Outlook 0
makinmyway Bulk Delete Contacts in iOS Outlook App Using Outlook 4
Diane Poremsky Macro to Bulk Import Contacts and vCards into Outlook Using Outlook 0
X Bulk edit Contact forms Using Outlook 2
Diane Poremsky Macro to Bulk Import vCards into Outlook Using Outlook 0
M Bulk Edit contact notes BCM (Business Contact Manager) 1
R VB code to bulk save attachments deletes message Using Outlook 1
C Outllook Migration - Office 200? - 2010 - Shared Mailbox Export-Bulk 500 users Using Outlook 1
H Bulk import of PST files into Outlook Using Outlook 1
S Why Cant i send lots of emails from my hotmail in bulk? Using Outlook 1
F Text Format Change - Bulk Edit Contact Notes Using Outlook 2
Q Outlook become non responsive if i write outlook item in bulk Outlook VBA and Custom Forms 20
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
G automatically choosing "add to autocorrect" option Using Outlook 0
F Want to add second email to Outlook for business use Using Outlook 4
K Add an entry to a specific calendar Using Outlook 1
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
J Outlook 365 Add keywords from Listbox to the message body where cursor is placed Outlook VBA and Custom Forms 0
O Add Day Number of the year for 2023-2033 Outlook VBA and Custom Forms 5
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 10
N How to add or delete items to Move dropdown Menu Using Outlook 0
G Add contacts birthday to calendar Using Outlook 4
V How to add 'Previous Item' and 'Next Item' to the Quick Access Toolbar Using Outlook 1
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
kkqq1122 How would I add Search for attachment name Outlook VBA and Custom Forms 3
L did MS ever add way to text via Outlook Using Outlook 5
P How to add a column named categories when searching in Outlook Using Outlook 0
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
Witzker Outlook 2019 Pls. add a Prefix for OUTLOOK 2019 here Using Outlook 1
P Add inanimate objects to meetings? Using Outlook 1
O Outlook 2010 Add delete button to the side of the message list Using Outlook 1
BartH Add a string to the conditions in .Conditions.BodyOrSubject.Text Outlook VBA and Custom Forms 2
A "Get Add-Ins" - Which Version of Outlook to use Using Outlook 1
D Do I need Exchange Add-In? Using Outlook 6
C-S-R Manage Add-ins (Remove Wunderlist) Using Outlook 6
A iCloud add in problems Using Outlook 4
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
C Looking for feedback on new Outlook Add-in Using Outlook 0
L isn't there an OL add-on that flags addressee before sending Using Outlook 3
S Add VBA save code Using Outlook 0

Similar threads