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

[Paul Hartland]

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