Converting Script to HTML

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

Workflow

Output

Accepted answers

All comments

apathetichell

There are no attachments.

KamenRider

HI @apathetichell

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

thanks,

Kamen

script.docx

binu_acs

@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

Hi @binu_acs

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.

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

AncientPandaman

@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.png Screenshot 2024-02-14 152611.png Screenshot 2024-02-14 152740.png

email.yxzp

KamenRider

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

binu_acs

@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

Hi @binu_acs

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

binu_acs

@KamenRider If 256 characters are the limit of the email, then I think the only option is to create the distribution list, which gives you the flexibility to modify the email addresses without touching the Alteryx workflow

KamenRider

Hi @binu_acs

The html code you have shared is working in showing the complete email address or recipients. All I need to know is how to incorporate this in Alteryx. How other Alteryx tool or the sample workflow created by @PangHC will be incorporated with the html code you have created and I think it will works.

Hoping to hear from you.

Thanks,

Kamen

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703