Forum Discussion
Formula 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 a formula-type column? Bonus points if it can separate out to and cc into separate counts.
4 Replies
- Hornblower409Iron Contributor
This is my third attempt to post a reply. The first two never showed up here (Moderator Approval?). I'm assuming this was because they contains Outlook View Formula Code.
So this time it's plain text and pictures.
- Hornblower409Iron Contributor
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.
- Hornblower409Iron Contributor
View -> View Settings
[Columns]
[New Column]
Name: RepCount
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) You can look at the custom fields that you can add in Outlook Classic, the bar where "to" and "from" are, right click on that and find "fields choser" and you can look in there, 100's of options almost. Then drag the choice you select to the bar and then you can see more information.