Odd symbol when stripping characters using vba

H

hlock

I'm coming across an odd symbol when I'm trying to strip out the illegal
characters in the subject line of an email. I can't replicate the symbol,
but have a .jpg picture of it. In the email subject line it usually appears
as a blank space. In the vba statement it looks like a vertical line with
horizontal elbow line to the right. If anyone knows what it might be, do you
have any suggestions on how to remove it?
Thanks!
 
K

Ken Slovak - [MVP - Outlook]

What is the character value of that odd symbol? Use the ASC() function to
get a number so we know what you're talking about.
 
H

hlock

It is a tab character that is showing up in the subject line of some emails.
Ascii character 9. Since we use the subject line as the name of the email
file, I was able to replace it with an underscore. Thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top