I am trying to CC multiple people on an email template for a business event. I want our customer service department to be able to easily who is copied on these emails. so i added a checkbox to the customer (Contact table) screen. I then created a sql view that concats all the email addresses into one string. The business event always fails and says “Invalid Mail Address”. Below are screenshots. I tried changing the dac of the sql view to have that field be [PXDBEmail] and also string but i cant seem to make it work. Is what im doing possible? I did verify in one of the email fields that i can put multiple with “;” inbetween and it will send it to both, but i dont want our customer service to have to fill it out in that field everytime.
