We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Converting Script to HTML

KamenRider
11 - Bolide

Hi,

 

I would like to ask if it is possible to convert the script as per attached below into HTM or HTML in order to be viewable?  I would like to see the results first before sending it to recipients. I tried the browse tool and it is not working. I have tried attaching a layout and render tool and it is not working also. 

 

Hope to hear from anyone.

 

Thanks,

Kamen

11 REPLIES 11
apathetichell
20 - Arcturus

There are no attachments.

KamenRider
11 - Bolide

HI @apathetichell 

 

Here's the text file as attachment. Sorry for that.

 

thanks,

 

Kamen

binuacs
21 - Polaris

@KamenRider not sure this is something you are looking for

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Email with Embedded Image</title>
</head>
<body>

<h1>Email with Embedded Image</h1>

<!-- Mailto link to open default email client -->
<a href="mailto:recipient@example.com?subject=Subject%20of%20the%20Email&amp;body=%3Chtml%3E%3Cbody%3E%3Cp%3EThis%20is%20the%20email%20body%20with%20an%20embedded%20image%3A%3C%2Fp%3E%3Cimg%20src%3D%27C%3A%5CPath%5CTo%5CYour%5CImage.jpg%27%20alt%3D%27Embedded%20Image%27%3E%3C%2Fbody%3E%3C%2Fhtml%3E">Send Email</a>

</body>
</html>

 

KamenRider
11 - Bolide

Hi @binuacs 

 

Thanks for your response. I think this is something that will works since I am able to view the results before sending the email to different recipients. However I have some clarifications and additional conditions.

 

 

Email.PNG

1. How can we incorporate this to Alteryx?

2. Is it possible for the "TO" field to the read then input text tool that contains the name of recipients?

3. Can we add dynamic date in the subject wherein it will be getting its date in the formula tool?

4. Apologize, I am not an html expert. I am seeing strings like percentage in the code. Is there a way I can read it well in order for me to enter the text, for example, the path of the image?

5. I have attachment, can you please add a code? This will be reading a date in the formula tool as part of the filename.

6. Can you also add a code wherein it is possible to add the signature at the end of the email wherein it will reading/getting the details from the formula tool?

 

Here's the sample layout of the email output what is on my mind.

 

sample layout.PNG

Apologize for the long details. I do hope you can help me this. Thanks,

 

Kamen

KamenRider
11 - Bolide

Hi @binuacs 

 

Could I follow my request if the requirements about is feasible?

 

Thanks,

Kamen

 

PangHC
13 - Pulsar

@KamenRider i think you just need some simple reporting text + email tool. 

you may need some help from IT in your company about the SMTP + port

 

Screenshot 2024-02-14 152744.pngScreenshot 2024-02-14 152611.pngScreenshot 2024-02-14 152740.png

KamenRider
11 - Bolide

Hi @PangHC 

 

Thanks for the response. Actually my workflow looks like this. My only issue with this one is that it truncates the recipients email address. We have recipients of 50 or more in the "TO" field and it only shows about 254 characters or about 6 to 7 email address in the email as results. If you can show me wherein it accepts the complete 50 email address in the email once sent, then ill accept this as solution.

 

Hoping to hear from your expertise.

 

Thanks,

Kamen

 

binuacs
21 - Polaris

@KamenRider Why don't you create an email distribution list and include the 50 mail recipients' addresses then use that one distribution list in your workflow?

KamenRider
11 - Bolide

Hi @binuacs 

 

Since we are automating the process, our client don't want any changes when it comes to email address listing. They would like it as ease. Aside from that creating a distribution list will be a challenge for us since we don't have rights to do it. It would take time and effort of requesting.

 

This is the reason why we are finding ways to list the emails without missing and one solution applicable to us is the use of scripts/html where we have the control to edit, modified or update it anytime.

 

I do hope you can help us this.

 

Thanks,

Kamen

Labels
Top Solution Authors