Hi,
Earlier I have used the email tool to output an attachment like .csv, .xlsx files. Now I am trying to embed the output directly into the body of the email. For example my output includes customer info with 8 columns and want to insert that into the body of the email. I tried using Table, Layout tool by referring to articles but nothing seems to work and I'm not receiving any email to my inbox. Wanted to see if there is a way to do this instead of using an attachment? Thank you in advance
@aparna0208 I think your text might contain some non-printable characters, which might be causing the issue. Can you use the regex formula below on the Salesforce connector field before passing it to the Table tool to remove non-printable characters and try again? Also, change the data type of the fields to v-string using the select tool if they are not already
Regex_Replace([Field],[^ -~],'')
@alexnajm @jrlindem @binu_acs @abacon A big thank you to all for looking into this issue and providing inputs. Wanted to provide a quick update. Looks like this has something to do with Salesforce connectors and the only reason I was not getting any email. I did a small workaround where I run the connectors in a separate workflow and write to a .yxdb file and use that output in my workflow and now everything is working and I am receiving the email as expected.
