VBA unknown character (MS Outlook)

[Lacisnesnon]

Hi all,
I know this is for Excel, but MS Outlook uses the same VBA engine?

I have emails with subjects from a specific authority that includes a special character. It shows up as a couple of spaces or a tab in the email subject in Outlook, however, when manually file saving the target email Outlook has already removed this character from the subject.

I have a file saver macro module that processes a selected email and saves it to a predetermined location, however, when it extracts the subject from the email it includes this special character which shows up in the error message as a SQUARE (not [] as there are no pixel spaces between the two brackets). See attached images for examples.

I have tried processing all special characters that I am able to with no resolution. "#$%()^*&/\:;*?<>+[]." The error still persists.

I guess the only other way is to write code that will process each character in a string until there is an error which then records the error character number in the string and replaces it with something valid. I don't want to have to do this for all emails.

Any ideas would be appreciated.
Thanks in advance

 

[Lacisnesnon]

Solved it.

Turns out to be chr(9),

Chr(9)

HT

Horizontal Tab

ASCII CHR() CODE CHART for QTP, UFT and Selenium

Fixed by searching for the chr code using
MsgBox Asc(Mid(sName, 28, 1))