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

[John Colby]

Is this a "prince from Nairobi" scam thing?😁

On Tue, Aug 20, 2024 at 12:10 PM 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
>


-- 
John W. Colby
Colby Consulting