[AccessD] vbSendMail - Email Body Converting £ Symbol To Garbage

[Rocky Smolin]

I had a similar problem when I translated my manufacturing system to
Chinese. Had to learn all about Unicode.

Maybe this would help?
"£" U+00A3: Pound Sign (Unicode Character) (unicodeplus.com)
<https://unicodeplus.com/U+00A3>

More ideas here:
Correct ASCII value of Pound sign - Stack Overflow
<https://stackoverflow.com/questions/24675040/correct-ascii-value-of-pound-sign>

HTH

r

On Tue, Aug 20, 2024 at 9:10 AM Paul Hartland via AccessD <
accessd at databaseadvisors.com> wrote:

> To all,
>
> I am using VB sendmail and populating a string with various data and before
> each numeric value I am checking the currency code and placing the
> appropriate currency symbol in front of the value.
>
> strCurrencySymbol = "£"
>
> The text string will be something like "payment to your account of " &
> strCurrencySymbol &  format(.field("MyValue").value, "#0.00") & " by"
>
> Works fine in tests with me sending the emails to myself, client tries to
> send one to their client and where the £ sign is supposed to appear as in
> the screenshot below.
>
> [image: image.png]
>
> Anyone know why this would happen, I have read about UTF8 encoding, but
> doesn't seem to be an option in vbSendMail looks like we use MIME encoding
> at the moment,
>
> Thanks in advance for any help
>
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>