Good Day Everyone ! The output of my data is a table which has a URL as one of its fields, as listed in the image below. My requirement if to click the URL and trigger an outlook email in the below format (image 2) Is there any Alteryx functionality that can help me explore this ?? Upload Invoice feedback Difference Ask Supplier Click here Click here Click here Click here The outlook email that needs to be triggered upon clicking the URL above is in this format Can this be done using Alteryx ? Regards

Triggering outlook emails from Table field values which are URL's

Good Day Everyone !

The output of my data is a table which has a URL as one of its fields, as listed in the image below. My requirement if to click the URL and trigger an outlook email in the below format (image 2)

Is there any Alteryx functionality that can help me explore this ??

Upload Invoice	feedback	Difference	Ask Supplier
Click here	Click here	Click here	Click here

The outlook email that needs to be triggered upon clicking the URL above is in this format

Can this be done using Alteryx ?

Regards

Data Investigation

Accepted answers

AbhijeetChib

Hello @HomesickSurfer

Thank you very much for your help. One last question, seems complicated.

The below links in the table triggers emails that i just finished. The emails have subject line with 5 dynamic fields. 4 of them are from a source file which i have concatenated and passed to the email subject, however the fifth parameter is based on what link the user clicks.

For example please consider the below screenshot

If the user clicks Upload Invoice, the UIN is passed as the 5th parameter to the email subject.

ABCD1234,123456789,001,002,UIN

If the user clicks Awaiting invoice feedback AIF is passed to the email subject.

ABCD1234,123456789,001,002,AIF

I hope i was able to explain you.

Thanks again for your help.

All comments

HomesickSurfer

Hi @AbhijeetChib

Work with the Add Hyperlink:

Add mailto: in from of the address

Or, ?subject=

Or, dynamically...

Edit: use a formal expression after the Report Text to omit the http:// prefix from the email address...

Replace([Text], "http://", "")

AbhijeetChib

Thanks a lot @HomesickSurfer

Do you recommend using to Formula tool after the Report. I am able to eliminate the "http://"

But when i run the File it gives an error

Here is a screenshot

Here is the error

Any idea ?

AbhijeetChib

Also, i tried to hard code the email field, as its only 1 email and added the subject line field dynamically, it would not populate. One static once dynamic does not work does it ?