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

[Paul Hartland]

Thanks Rocky, will take a look when I get into work tomorrow.

Paul

On Tue, 20 Aug 2024, 19:06 Rocky Smolin, <rockysmolin2 at gmail.com> wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>