Using the Send Email Command in Visual Script editor in V9

I am trying to send an email to a list of users with the Send Email command in the Visual Script editor in V9. I am able to get it to work sending an email to 1 user with either GetEmailAddress("user1") or GetEmailAddresses("user1"), but I cannot get it to work for more than one user. I am using GetEmailAddresses ("user1", "user2") in the "To" expression builder. Both users come up in the Get Email Addresses payne below the expression builder.

Find more posts tagged with

BPM

Comments

Jerome_Pearce

Can you see what is trying to be sent? It would probably be in teh SMTP logs somewhere. I'll be willing to bet that the list of email addresses is not delimited correctly, and you have something like "-removed--removed-".

---
Note: Some information in this post has been hidden to protect privacy.

Melanie Garside

Hi, did you ever get this sorted? I have the same issue, the expression builder will not actually accept my formula. Do we need to include a delimeter?

I am getting my list of users via a sql select statement

Lark Smith

The only way I got it to work was using the ReplaceSubstrings function, which is found on the Text drop down box in the Expression Builder. My SQL statement pulls email addresses from a table which are not separated by commas. I used the function to replace .com with .com, for all of the email addresses. If the addresses are delimited by tabs, replace the strimg “\u0009” with ", ".

Lark Smith

To clarify, I didn't use GetEmailAddresses. I pulled the addresses from a table using SQL code and assigned the string of addresses to a memo variable.

Jerome_Pearce

Lark wrote:

If the addresses are delimited by tabs, replace the strimg “\u0009” with ", ".

or "\t" for those unwilling to remeber or look up ASCII codes!

But if you convert to a memo, you will have to replace CRs which are "\r\n".