This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello !
I have a requirement where i am sending emails through alteryx and the emails have a URL in them. Upon clicking the URL an email is triggered in outlook with pre filled email body. The difficulty I am having is how to add lines in the content of the body. Here is a screenshot. I want the body and Field1 and Field 2 to be in separate lines when the email window opens in outlook. Currently all of the content if showing in just one single line.
Hey @AbhijeetChib ,
Check this great blog post from @FreeRangeDingo
https://www.bigmountainanalytics.com/how-to-include-line-breaks-in-an-alteryx-email/
Best,
Fernando Vizcaino
Hi @fmvizcaino
I made the change but in the email trigger, it just adds the </b></b> in the email body.
@fmvizcaino Thank you for sharing my writing!
@AbhijeetChib Can you share a screenshot of your formulas pls.
@FreeRangeDingo here is the formula tool for the field value - AIS_Email Body
This formula then goes to the Report Text tool. Where I need to create a link, which when clicked triggers an email with the Field AIS_Email Body as the body of the triggered email from clicking the link. The issue if everything is just coming in a same line.
I tried with the available fields option as well but, it always stays in the same line.
(I have changed the field names)
You need to include the HTML in your formulas. I use the replace expression to replace the carriage returns with the HTML in my third formula shown below. That is what you are missing.
https://www.bigmountainanalytics.com/how-to-include-line-breaks-in-an-alteryx-email/
This is a screenshot from the blog post that shows it.
@FreeRangeDingo I have tried that, after watching your video but do they work in the Report text tool ? Also when i tried it just kept printing <br/> in the triggered email
I haven't tried with the Report Text tool, only Email tool.
@FreeRangeDingo in another simplified example, every change is line is replaced by <br.> but it just prints it instead of changing the line