Character limit in email output

[Dittau]

Is there a character limit in each to, cc, bcc fields in the email ouput tool? If so, what is the limit?

[DataNath]

Hey @Dittau, from what I've seen in other discussions this is 264. You can work around this by having a record for each recipient i.e. having them all on their own row, instead of a concatenated list.

[Dittau]

Is it 264 characters total among all of the options (to,cc,bcc) or 264 per item (cc: 264, to:264…etc)

also, could you demonstrate the workaround you mentioned?

[DataNath · Accepted solution]

@Dittau so if you're hitting the character limit, you'll have a list like this, separated by something like a semi-colon:

To get them into their own records, just use a Text-to-Columns, specifying whatever delimiter you have and splitting to rows:

If there's a space as well like in my example then just trim that:

Now you can just plug your Email tool in and it'll send one email per record to that person.

If you're using CC and BCC too, you might want to build in some logic so that they only get placed next to a single record otherwise they'll receive emails for every single one!

[ArnaldoSandoval · Accepted solution]

@Dittau 

Depending on your use case, you may consider creating Mailing List in your email server, you send your mail to the pre-define mailing list address and the email server distributed the information, just Google "Mailing List"

Mailing list 

Google search "Mailing List" 

hth

Arnaldo