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

[John Colby]

LOL.  I gotta make money somehow.  That nigerian prince....

On Tue, Aug 20, 2024 at 3:15 PM Paul Hartland via AccessD <
accessd at databaseadvisors.com> wrote:

> No totally legit for a large company, we aren't all like you John lol
>
> On Tue, 20 Aug 2024, 20:07 John Colby, <jwcolby at gmail.com> wrote:
>
> > 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
> > --
> > 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
>


-- 
John W. Colby
Colby Consulting