Populating text field with Email Addresses

Hello Team,  I have a text field in one of our Demand Requests that I want to use as a token for sending out an email notification.  I would like to know if I can string multiple email addresses in the field.  Right now I have a rule that populates this field as follows:

 

SELECT
'ml.is.posdeploy@heb.com;
ml.possm@heb.com', 'ml.is.posdeploy@heb.com;
ml.possm@heb.com'
FROM DUAL

 

I appears that I may be having issue using a semi-colon to separate the addresses so should I use a comma or is there a special syntax I should use?  Or can this even be done?

 

Appreciate any suggestions, advice.

Frank

Parents Reply Children
No Data