Sending HTML Email with Email Tool

[Inactive User]

I haven't had any success attempting to send a HTML format e-mail using the Alteryx E-mail tool.  The tool doesn't recognise when the body is HTML or provide the option of configuring the tool to send the e-mail as HTML format.  As a result the HTML gets sent as plain text. 

The render tool can be used to render the HTML into an image and passed into the Body of the Email tool however this means that an image is sent rather than HTML and the href links can't work.

I'm currently sending e-mail using the bmail command line client (in a Run Command tool) so that e-mails can be sent as HTML.

Has anyone else experienced this problem or found a solution using built in tools?

[masontrullinger]

It sucks to have to downgrade to regain functionality that we have relied on for so long. We use Alteryx for so many processes that output HTML formatted emails using this method. 

[Danny-Farrar]

Hey guys! I was wondering if this was still an issue whereby the workaround won't work on the most recent versions of Alteryx? I've tried the method but it's just sending a blank email - did anyone manage to figure out a new way of achieving the html email? 

Currently moving images of rectangles around to try to create some level of customisation but...it looks awful haha

[brianscott]

It seems 2020 builds removed this work around.  (?)  We have written an integration to SendGrid to get there.  

[jdrummey]

Hi @brianscott , have you done any more testing on this? I tried using 2020.3 using the <![CDATA... trick and I'm not having any luck.

Jonathan

[Jérémie]

Hello @brianscott, Hey @jdrummey !

I was wondering if there was a workaround since the 2021?

Best regards,

Jérémie

[jdrummey]

Hi @Jérémie , I haven't tried...when I need to send HTML emails I've used other tools.

[masontrullinger]

We too rely heavily on using Alteryx to send HTML emails and are forced to be stuck on Designer 2022.1.1.25127 to ensure this functionality doesn't break.

[Rod0Davis]

I have been able to send HTML emails.

Don't use full HTML.  Just make your body an HTML snippet. Here are two example body formulas I have used that work very well:

1.

"<p style='font:Calibri;font-size:12.0pt;color:black'>The attached report file " + [File Name] + " created on " + DateTimeFormat([RUN_DATE], '%m/%d/%Y') + " has been generated for your use.</p><p style='font:Calibri;font-size:12.0pt;color:white'>.</p><p style='font:Calibri;font-size:9.0pt;color:black'>Classification: Internal</p>"

2.

'The data load process has completed for ' + DateTimeFormat(DateTimeToday(),'%A') + ', ' + DateTimeFormat(DateTimeToday(), '%m/%d/%Y') + '.<p>Files written to: <a href="xxxxxxxxxxxxxxxxxxxxxxxxxxx">Prod Data Landing</a></p><p>Summary:</p><p style="margin-left: 40px">Found ' + ToString([Elements_Found],0) + ' elements.</p><p style="margin-left: 40px">Found ' + ToString([Data_Record_Count], 0) + ' data records for ' + ToString([Valid_Count],0) + ' active elements.</p><p style="margin-left: 40px">Found ' + ToString(ToNumber([Unique_User_Name_Record_Count]) + ToNumber([Unique_User_Name_Record_Count_2]), 0) + ' unique user names.</p><p style="margin-left: 40px">Producing ' + ToString([Update Record Count], 0) + ' records updated within the past 5 days.</p>' + [Missing Keys] + '<p style="margin-top: 40px">Technical Staff</p>'