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

[Jim Dettman]

<< but doesn't seem to be an option in vbSendMail looks like we use MIME encoding
at the moment,>>

  vbSendMail is very out of date at this point....I'm surprised your able to send e-mail with it at all.   You must be using a relay.

  Loved vbSendMail and used it for a number of years, but with no 64 bit support and outdated authentication methods, I had to move on.  

Jim.

-----Original Message-----
From: AccessD On Behalf Of Paul Hartland via AccessD
Sent: Tuesday, August 20, 2024 12:09 PM
To: Access List <accessd at databaseadvisors.com>
Cc: Paul Hartland <paul.hartland at googlemail.com>
Subject: [AccessD] vbSendMail - Email Body Converting £ Symbol To Garbage

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