HTML code not working

38 views
Skip to first unread message

FRANK WEISS

unread,
Jul 30, 2025, 12:43:34 AMJul 30
to NV Form Mule Add-on
I'm having difficulty getting a hyperlink to work when email is sent to microsoft outlook. The formula seems correct, and works fine when previewing the message in the message template (using formmule), but when sent, it does not work, I just get the text returned in the email (no active hyperlink). Any help??

Joseph Schmidt

unread,
Jul 30, 2025, 10:00:58 AMJul 30
to nv-form-m...@googlegroups.com
You don't show what you have.

See 
<a href="https://www.example.com">Visit Example.com</a>



On Wed, Jul 30, 2025 at 12:43 AM FRANK WEISS <wei...@friscoisd.org> wrote:
I'm having difficulty getting a hyperlink to work when email is sent to microsoft outlook. The formula seems correct, and works fine when previewing the message in the message template (using formmule), but when sent, it does not work, I just get the text returned in the email (no active hyperlink). Any help??

--
You received this message because you are subscribed to the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-form-mule-add-on/8db45762-29eb-435b-8b6a-af070193eca2n%40googlegroups.com.

Bart van Dalfsen

unread,
Jul 31, 2025, 11:52:17 PMJul 31
to nv-form-m...@googlegroups.com
Hi Frank,

Outlook problems? What's new :)
This bloated email client application has many 'automations' which can be turned off and on making predictable results as a mail sender pretty small.

The issue you have can probable be described as follows:
In the body I specified the text https://my.website.com/path/file.html  but Outlook fails to automatically recognize and format this as an active clickable link within the email.

You should have been specific to begin with and not rely on the software of the recipient to fix what you left out:
the <html> code which made links possible.

This is however a precise task in a sheet as the " double quotes symbol must be part of the outcome whilst being interpreted by the sheet to determine data from instructions.

e.g. ="Firstname:"&C2  may give "Firstname: Frank" but not the CHAR(34) surrounding Firstname: earlier.

to get a working hyperlink to:

you have to specify:

but more elegant would be to produce a human readable hyperlink instead to for instance:
 Click this link to our website

by specifying:
<a href=”https://my.websites.com/path/file.html”> Click this link to our website</a>

from first < to last > ought to tell even stuborn Outlook what to do exactly. (Show 'Click this link to our website' and open a browser to the hyperlink: https://my.websites.com/path/file.html

 If you need to cook user-specific links, using the data from the column B:B you have to compose them like in for example Z1:
=ARRAYFORMULA( IF( ROW(A:A)=0, "Custom Link",
IF( LEN(A:A)=0, "",
"<a href=”
&CHAR(34)
&B:B&
&CHAR(34)
&"> Click this link to our website</a>"
)))

The Title / Range name will be 'Custom Link' but make sure it's unique() and comprehensible.
And your hyperlink will refere to:
As where mine will be

Yet will read in the email-client of our choosing:
 Click this link to our website
although the underlying hyperlink differs clearly.

But you're probably dazzled by now and in need of a lazy rainy holiday like me ;)

Cheers, Bart

Op wo 30 jul 2025, 06:43 schreef FRANK WEISS <wei...@friscoisd.org>:
I'm having difficulty getting a hyperlink to work when email is sent to microsoft outlook. The formula seems correct, and works fine when previewing the message in the message template (using formmule), but when sent, it does not work, I just get the text returned in the email (no active hyperlink). Any help??

--
Reply all
Reply to author
Forward
0 new messages