Weird symbols in subject Outlook after using macro in Excel

[SWW39]

Hi there,

I have something strange with the interaction between excel and Outlook.

I'm using a VB macro that sends the data from an excel as an email attachement to a customer.

Since i'm having a new computer with a new version of Windows and Office, the subject of the e-mail has strange symbol (looks like chinese characters). In the past there was no problem, and when i'm using the file on another PC, there is no problem.

This is an example of the subject: सԀ撩꒭몳࢘ࢤ庫擇


Can someone help?


Best regards

 

[mole999]

can you highlight and change the font, to see if its just got converted

 

[SWW39]

can you highlight and change the font, to see if its just got converted

How can you do that?

 

[mole999]

OK, what is the macro you are using, post here between code tags

 

[SWW39]

OK, what is the macro you are using, post here between code tags

 ' Application.Dialogs(xlDialogSendMail).Show
    Dim lijn As String
    lijn = "Company name: Company nr : " & Range("c2") & " PO : " & Range("c3") & " - na te kijken en goedkeuring geven"
    ' ActiveWorkbook.SendMail Recipients:="me@hotmail.com", Subject:=lijn

 

[mole999]

so the subject Company name: Company nr : " & Range("c2") & " PO : " & Range("c3") & " - na te kijken en goedkeuring geven"
is being converted to सԀ撩꒭몳࢘ࢤ庫擇

I think somehow it needs to be forced to use a Dutch dictionary, but I'm not sure how thats done

 

[SWW39]

so the subject Company name: Company nr : " & Range("c2") & " PO : " & Range("c3") & " - na te kijken en goedkeuring geven"
is being converted to सԀ撩꒭몳࢘ࢤ庫擇

I think somehow it needs to be forced to use a Dutch dictionary, but I'm not sure how thats done

One step further then...somebody else?

Thanks already!

 

[toaojs]

My company just recently upgraded from Office 2010 to 2016 . I have an excel vba script that uses an array version of

ActiveWorkbook.SendMail "email@email.com", "This is the Subject"

It has worked error free for years in Excel 2010, however in Excel 2016, we are seeing similar odd characters (⯐皑ᝠ#ߐ#礁筺絼罾膀莂薄螆) in place of "This is the Subject" in the Subject line of sent emails. Everything else with the email (email addresses and attachment) are sent & received as expected.

I have tried several different variations in the script using different combinations of text and variables with no success. I've gone as far as creating a blank workbook with just the simple line of code above and get the same results.

We still have a couple computers still running Office 2010 and I am able to remote in and run the scripts side by side with my computer (Excel 2016) and all of the variations work as expected in the old version and are abysmal failures in the new one.

I'm not sure if this is an Excel or Outlook issue. I know it isn't a font issue, because the text is the same regardless of the font selection.


Any suggestions would be greatly appreciated. I thank you in advance.

 

[mole999]

i would think you have two different fonts, one unicode which has a wider range of characters, but that is only a guess