How to show concatenated categories in list task view?

bkper087

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Is there a way to sort Tasks by Category in a table view, but concatenate the Category if there is more than one? I have tried creating a custom field using [Category]&" "&[Category] but that doesn't show the second (or third or fourth, etc) category. This would be SUPER helpful if I could figure this out. I've honestly been trying for YEARS! You could be my savior....

Check the attached image for a screen shot.

What it currently shows looks like this: "Category 1"
What I want it to show would look like this when grouped by category under Category 1: "Category 1; Category 2"

In other words - list the category it is grouped underneath first, but also list where it appears in other categories

Outlook.jpg
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Since a custom field doesn't work when you group by categories, you'll need to use a macro to write the category field to a new field..

This has the general idea - but you'd need to run it after updating categories.
 

bkper087

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
I am familiar in general with VBA but most of my experience is in Access. I played with it a little, but if I am following the example code you linked to it is designed for a single line edit.

I am really looking for this to display for all tasks grouped under each category. Not just a single one at a time. Can this work? Sorry, having difficulty translating the example into what I am going for.
 
Thread starter Similar threads Forum Replies Date
C How to use VBA to show only items x days old or more Outlook VBA and Custom Forms 1
L Option to Show Cancelled Appointments Using Outlook 0
M Outlook .com group does not show up in Outlook for office 365 home Using Outlook 3
F Appointment Show All Fields Using Outlook 1
G Calendar View in Outlook Office 365 - Doesn't show enough hours, and the 30/60 min choice isn't the solution Using Outlook 4
N How to disable shortcuts for Pilcrow in Outlook (Show or hide paragraph marks) Using Outlook 0
V Outlook Macro to show Flagged messages Outlook VBA and Custom Forms 2
F How to show assigned tasks under certain mailbox? Using Outlook 4
witzker social connector 2010 does not show all emails to or from contact Using Outlook 3
witzker social connector 2010 does not show all emails to or from contact New Slipstick.com Articles 0
S Outlook.com birthdays show up 1 day late on iPhone contacts list Using Outlook.com accounts in Outlook 28
A Outlook 2016 Will Not Show Any Data In the People Pane Using Outlook 14
Rupert Dragwater Email flag does not show up in Outlook2013 Using Outlook 13
S Show Total Number Of Items Not Displaying Using Outlook 9
Z Tasks from some users show up as emails Using Outlook 4
Caio "From" field doesn't show extra email addresses in Outlook 2016. Using Outlook.com accounts in Outlook 6
O Worksheet doesn't show on jumplist Using Outlook 1
J Outlook 2013 when clicking To in a new email show Company names Using Outlook 0
C Outlook 2016 doesn't show contacts in address book Using Outlook 2
K Daily task list > show tasks on the exact due date and not on the "current date" Using Outlook 1
Rupert Dragwater Some mailboxes show deleted items as not read Using Outlook 5
C Discovery search does not show autoforwarded messages Exchange Server Administration 1
Thorsten show the correct calendar on start Outlook VBA and Custom Forms 5
M Marco doesn't show up when using Alt-F8 Outlook VBA and Custom Forms 2
I Windows 10 - .msg files on disk show Explorer popup error Using Outlook 5
Phillip Show mail items in folder macro Outlook VBA and Custom Forms 2
H How to show recipient email address? Using Outlook 0
H Is it possible to create a view that only show the first task in a list? Using Outlook 1
Diane Poremsky Make the Address Book show only e-mail addresses, not fax numbers New Slipstick.com Articles 0
G Outlook does not show new appointments in To-Do-Bar Using Outlook 0
L How to show Delivered-To field in Inbox Using Outlook 1
T Desktop alerts show but no emails found Using Outlook 1
oliv- How to select an mailitem in explorer with "show as conversation" Outlook VBA and Custom Forms 8
N To do bar - show more than 30 days of appointments Using Outlook 0
V move emails to windows folder and show sender details Using Outlook 7
M No Show Group on ribbon Using Outlook 8
J Outlook Rules not show Master Category List Using Outlook.com accounts in Outlook 4
A Show ALL of today's appointments in To-Do Bar Using Outlook 1
D Mail accounts don't show up in navigation pane Using Outlook 1
wisedave Missing icon that show message was forwarded, etc Using Outlook 1
S Need CC: to show the original To: recip[ients Using Outlook 4
C iCloud addresses don't show up in "Address Book" or "To:" Using Outlook 5
J Show three or more months in Calendar Using Outlook 1
U Subdirectories in people don't show up in the address book Using Outlook 1
1Firefly Outlook 2013 Converstation preview does not show my last reply Exchange Server Administration 1
J How to show the "value" of a user-defined Account field in a Contact Record BCM (Business Contact Manager) 2
D Setting defult "Show a room list" Using Outlook 0
D Custom Form - Show field-filled doc a or b based on value of field x Outlook VBA and Custom Forms 4
T Error" There are no items to show in this view" for Outlook 2007 with 16GB pst Using Outlook 2
D How to show just the date in an Outlook 2010 Journal view Using Outlook 1
Similar threads


















































Top