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
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
can you highlight and change the font, to see if its just got converted
 
Upvote 0
OK, what is the macro you are using, post here between code tags
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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!
 
Upvote 0
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.
 
Upvote 0
i would think you have two different fonts, one unicode which has a wider range of characters, but that is only a guess
 
Upvote 0

Forum statistics

Threads
1,223,958
Messages
6,175,632
Members
452,661
Latest member
Nonhle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top