0

I'm trying to put foreign language (Myanmar/Burmese) in email body.

The word turned into gibberish characters when it is sent, showing "???????".

Is there a step I'm missing or a workaround?

I tried changing the setting in VBA (i.e. Tools> Options> Editor Format> Myanmar Text(Western) and changing my laptop region setting to Myanmar also.

When I put Myanmar language characters, I expect to see

.HTMLBody = "Hello " &အကြီးစားလုပ်ငန်းကြီးတွေသာမက&_

What happened

.HTMLBody = "Hello " & အကြီးစားလုပ်ငန်းကြီးá€á€½á€±á€žá€¬á€™á€€ & _
Community
  • 1
  • 1
WaeYan2993
  • 1
  • 1
    Hm, find the byte code for the character and use it instead in your code (`System.Encoding.UTF8.GetString()` or something like that should be in BCL in .NET) – Michał Turczyn Nov 16 '22 at 07:42
  • Store your text in an Excel cell and do `.HTMLBody = "Hello " & cell.Value`. Then you don't need to switch your laptop to anything. – GSerg Nov 18 '22 at 21:32

0 Answers0