I am using Calc to generate an email via a “mailto” Hyperlink. The email hyperlink includes a Mailto section, a Subject section and a body section. Various parts of the email are created through formulae on the spreadsheet.
This all works apart from an annoying problem. I need to include a UK currency symbol = £ in the email body. This £ symbol is converted into the characters Â£30 in the generated email. I need it to show £30 without the “Â” character.
Is there any way to do this?
If it is relevant I am using Microsoft LiveMail as my email client. Yes I know it is no longer supported but it works. I can’t find another client that allows me to take a daily backup of individual emails. All other clients put all the emails into a single email files which is too large to backup.
I have simplified my problem.
Here is the code entered into the cell:
=HYPERLINK("mailto:email@example.com?subject=test&body=a message containing £30 etc")
When I use CTRL + Click my mail client LiveMail opens and displays
a message containing Â£30 etc
I am using Windows 10 Home edition, version 1809, build .18363.657
I am using UK Locale.
My email client is Microsoft Livemail. I cannot find any language settings I assume it is using the OS default
My LibreOffice language settings are all UK
LO Version: 184.108.40.206 (x64)