Weird symbols in subject Outlook after using macro in Excel

SWW39

New Member
Joined
Jan 29, 2016
Messages
4
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
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,334
Office Version
2019, 2016, 2013
Platform
Windows
can you highlight and change the font, to see if its just got converted
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,334
Office Version
2019, 2016, 2013
Platform
Windows
OK, what is the macro you are using, post here between code tags
 

SWW39

New Member
Joined
Jan 29, 2016
Messages
4
OK, what is the macro you are using, post here between code tags
Code:
 ' 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

Moderator
Joined
Oct 23, 2004
Messages
10,334
Office Version
2019, 2016, 2013
Platform
Windows
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

New Member
Joined
Jan 29, 2016
Messages
4
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

New Member
Joined
Aug 1, 2017
Messages
1
My company just recently upgraded from Office 2010 to 2016 :banghead:. 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

Moderator
Joined
Oct 23, 2004
Messages
10,334
Office Version
2019, 2016, 2013
Platform
Windows
i would think you have two different fonts, one unicode which has a wider range of characters, but that is only a guess
 

Watch MrExcel Video

Forum statistics

Threads
1,098,869
Messages
5,465,184
Members
406,417
Latest member
Revolution_72

This Week's Hot Topics

Top