Forum Discussion
shadowsinger
Microsoft
MicrosoftFormula columns in classic Outlook - count of recipients?
Rather than the standard "to" column that shows the names of everyone the email was sent to, I would like to see a count of aliases the email was addressed to. Is this something that can be done with...
My original answer didn't seem to make it past Mod approval. Perhaps because of the included Outlook View Formula in a Code Block. So here it is again as all plain text.
View -> View Settings -> [Columns] -> [New Column]
Name: RecipientCount
Type: Formula
Formula:
"To: " & IIf(Len([To]),Len([To])-Len(Replace([To],";",""))+1,0) & ", CC: " & IIf(Len([CC]),Len([CC])-Len(Replace([CC],";",""))+1,0) & ", BCC: " & IIf(Len([BCC]),Len([BCC])-Len(Replace([BCC],";",""))+1,0)
The idea is that multiple Recipients in the [To], [CC], and [BCC] fields are semi-colon separated, so (if the field is not empty) you can calculate the difference in the field length with/without semi-colons to get the count.