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

[AbhijeetChib]

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 

[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 ?

[HomesickSurfer]

Hi @AbhijeetChib 

The 'div class' in the results is not an error.  That's expected.  Please try the attached workflow

[AbhijeetChib · Accepted solution]

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.