Using the Send Email Command in Visual Script editor in V9

Lark Smith
Lark Smith
in AppWorks #1

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. 

Tagged:

Comments

  • Jerome_Pearce
    Jerome_Pearce
    #2

    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
    Melanie Garside
    #3

    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
    Lark Smith
    #4

    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
    Lark Smith
    #5

    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
    Jerome_Pearce
    #6

     

    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".

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform