Summarize Tool, Email Tool, "This Cell Has Truncated Characters"

kkahle

Hi,

I have a column of email addresses. I'm attempting to use the Summarize Tool to concatenate the values (email addresses) into a single cell.  The new cell with all of the email addresses will be used as the " To: " value in the Email Tool.

After I concatenate the email addresses there is a message on the new cell that reads "This Cell Has Truncated Characters". I can use an output tool after the Summarize Tool and all of the email addresses are present (not truncated) in the output file but when I try to use the new cell as the " To:" value with the Email Tool I receive an error that reads "Record#1: Failure when receiving data from the peer".

The workflow runs without any errors if I'm only using 2 or 3 email addresses but I'm trying to send the output to 100 or more email addresses.

I think the error is being caused by the truncated email addresses. The Email Tool can't send a message to half an email address. 

I've tried changing the data type to all the different types of string data.

Has anyone found a solution for this issue?

Please let me know if there's any other info that would be helpful.

Thanks!

Error Example.yxmd

mceleavey

Hi @kkahle ,

This is probably due to the limitations of the length of characters allowed in the "To" field.

The way around this would be to wrap the email tool in a batch macro, use the summarise tool to simply group by the email address, and use this field as the batch. That would then loop through and send an email per email address.

Let me know if you need me to build that for you.

M.