Difference between TO and Recipients field on sys_email table in servicenow

[Gayathri5]

Hi Community,

Happy New year all.

May i know what is the difference between "To" and "Recipients" field on sys_email table?

I am assuming recipients field contains cc, bcc and to doesn't...am i right?Please confirm

Regards,

G

[Gayathri5]

Ya i had used recipients only , just crosschecking here in community, to understand the difference between 2.

[Rai2]

Hi @Ankur Bawiskar, 

Why Recipients is better to use? Thanks

[Community Alums]

Hi @Gayathri5 ,

In terms of the Sys_email table :

 Both "To" and "Recipents" would be same content/ email addressess.

Copied and Blind copy is again separated fields. See below :

[Anders Pr_steg1]

Hi,

I just wanted to share that I have a different experience than seen on Sandeep's screenshot (I can't share it, you have to take my word for it). I see many examples in my company instances where recipients sums up To and Copied (presumely to simplify conditions):
recipients: 1,2,3,4,5
To: 1,2
Copied: 3,4,5

EDIT: In relation to what I just wrote the condition field evaluation behaves different than (opposite to) script variables:

email.to	Contains a comma-separated list of email addresses in the To: and Cc: boxes.
email.direct	Contains a comma-separated list of email addresses in the To: box.
email.recipients	Contains a comma-separated list of recipient addresses as a plain text string, in the To: box.

That is very confusing 🤔

Anders