mail_script why does it not populate the cc field?

andy_dufresne · ‎07-10-2017

Hello Gurus,

I created the following mail-script and tested in Scripts Background it is returning emails for sure:

Now In my email template I'm invoking it like this:

But when I click on email, it does not populate the cc list, can you help me?

Thanks in advance

andy_dufresne · ‎07-17-2017

Thanks to all who responded. I finally solved it and this is how:

Firstly the email.addAddress thingy did not work, *but* what was working is if I put a field name say 'description' in 'to' field it would populate the value from description in the mail-template. So ..

I created a new column say 'u_emailAddressHolder'
Created a insert/update business rule that will update email addresses into this column based on my query
Updated my template 'To' field with simply 'u_emailAddressHolder'

bingo all emails pop up.

I must give credit to Mr.David Hreben, who actually used this ingenious trick in the last message in here 🙂 Email Client

View solution in original post

Chuck Tomasi · ‎07-10-2017

The mail script doesn't go in the To or Cc fields. It goes in the message body and is run when the message is sent (you won't see the result in the email client template.)

Scripting for email notifications

Chuck Tomasi · ‎07-10-2017

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.

Thank you

andy_dufresne · ‎07-10-2017

Thanks Chuck,

I tried putting this in the message_body too, but still no result.

Nothing came up when I clicked the email button

this script does return the values so I'm pretty sure its not empty:

Chuck Tomasi · ‎07-10-2017

The mail script is run after you hit send. It isn't going to dynamically populate the values on the form. It's not a matter of whether it is running, but WHEN it is running. Have you tried a sample message and observed what is being placed in the outbox (and then sent)?