Small and medium business | Business Central, N...

Word Report email address as Hyperlinks

(0) Share

Report

Posted on by Hein Kruger

501

Hi,
We added Company Email as a CompanyEmail_Url to the customer statement.
All is looking good, The Email Address is shown as a hyperlink.

Here lies the problem. The Hyperlink adds /Http/ infront of the email address. This causes the email address to be seen as a website instead of an email address.
How can I modify the XML Hyperlink to be seen as an email address instead of a website?
See example below, we added sample@gmail.com in the company information table. We can see it as output on the word report. If we hover over it it. We can see the URL link is not correct.
If I add the email address manually into the report it works correctly by opening the email window and adding the email address to the CC.

Thanks in advance

Categories:

Business Central

All responses (2)

Answers (0)

Suggested answer

Yi Yong 1,350 Super User 2024 Season 2 on at

Like (0)

Report

Word Report email address as Hyperlinks

Hello Hein,

Adding _Url to the dataset will turns it into an URL and not a mailto.

If you want the email to look like a hyperlink, maybe you can try formatting it instead. I am not sure if there are better way.

Anyway, you can take a look at the standard report 1303 draft invoice.
gdrenteria 12,167 Most Valuable Professional on at

Like (0)

Report

Word Report email address as Hyperlinks

Hi

I hope this can help you.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-hyperlinks-in-word-report-layouts

BR

GR