vba Replace function not finding string

I have a very weird problem in trying to use the Replace function on the body of a template email. In the email I have a number of special phrases that I replace programatically in vba. e.g. "The captain is zzPlayerNamezz, and he will blah blah". I use the replace function to find and replace the zzPlayerNamezz in a kind of mail merge. This generally works fine but is sometimes very odd. For example If I try to replace "zzPlayerNamezz" it works fine but if try to replace "zzPlayerNamezz," it cannot find it.

the string is "According to our records your child, zzPlayerNamezz, is currently playing..."

the code is :
With MailItem
.htmlbody = Replace(.htmlbody, "zzPlayerNamezz,", "")

If iwere to use .htmlbody = Replace(.htmlbody, "zzPlayerNamezz", "") it works fine


what am I doing wrong??

Originally Posted by YasserKhalil

May be there is extra space after the string "zzPlayerNamezz" and before the comma like that "zzPlayerNamezz ," and this may cause that
In fact it would be correct using this line

Please Login or Register  to view this content.

as I tested something similar and worked for me well

Thanks for the thought but there are no blanks. If I take the comma out it finds the string without the comma but if I put it in it does not find it

I finally figured it out if anyone is reading this thread. The string I was checking was HTML code from an email template.
When I used the code zzPlayerNamezz it would show up as a spelling error when viewing the email template and was saved as such.
In the HTML code there was an inserted </span> code at the end of the spelling mistake.
If there was no comma after it then all was fine, however if there was a comma after the "zz" then the</span> code was inserted between the "zz" and the ",".
Hence the string was never found. Spellcheck the template ignore the errors so they no longer highlight and the problem goes away!

Originally Posted by noblerot

I finally figured it out if anyone is reading this thread. The string I was checking was HTML code from an email template.
When I used the code zzPlayerNamezz it would show up as a spelling error when viewing the email template and was saved as such.
In the HTML code there was an inserted </span> code at the end of the spelling mistake.
If there was no comma after it then all was fine, however if there was a comma after the "zz" then the</span> code was inserted between the "zz" and the ",".
Hence the string was never found. Spellcheck the template ignore the errors so they no longer highlight and the problem goes away!

THANK YOU!! I had the exact same problem and finally came across your comment to spell check (I added the terms to dictionary). You rock!!