Use of Chr(32)

[SteveHi]

Hello

When my SMTP (HTML) script emails a user, the user sees this: HelloUsersEmail (all one word), so I am trying to create a space between the word Hello and the users' email address by using Chr(32) as follows:

("Hello", Chr(32), & strEmailValue & ",<br /><br /> " & "To reset your password, please click on this <a style='color:#22BCES5' href=''>link.</a>", Nothing, "text/html")

but Visual Studio gives me a blue line under that first ampersand: 'Expression Expected'.

What am I missing, please?

[jmcilhinney]

You're missing the fact that you have a comma after 'Chr(32)' so that first ampersand isn't actually concatenating to anything.

That said, why use Chr(32) at all when you can just use a literal space? You should learn to use String.Format or, even better in later versions, string interpolation. Also, it's just plain silly to concatenation two literal Strings together. Why would you ever use this:

",<br /><br /> " & "To reset your password, please click on this <a style='color:#22BCES5' href=''>link.</a>"

in preference to this:

",<br /><br /> To reset your password, please click on this <a style='color:#22BCES5' href=''>link.</a>"

[SteveHi]

Thanks JmCilhinney

Your preference is preferable.

In relation to the space issue, this code:

"Hello" & "strEmailValue" & "

which actually has a space between "Hello"[space]"strEmailValue" is the one that generate this 'HelloUserEmail' (all one word).

I can check it again to be sure.

[SteveHi]

Thanks JmCilhinney

Your preference is preferable.

In relation to the space issue, this code:

"Hello" & "strEmailValue" & "

which actually has a space between "Hello"[space]"& is the one that generate this 'HelloUserEmail' (all one word).

I can check it again to be sure.

[SteveHi]

Yes, just as I thought.

This code:

("Hello" & strEmailValue & ",<br /><br /> To reset your password...

with the space between "Hello" and the ampersand:



produces this in my mail box:



Thanks for your advice.

[techgnome]

unless the space is INSIDE the string IT DOESN'T count...

("Hello " & strEmailValue & ",<br /><br /> To reset your password...

See how there is now a space immediately after Hello? THAT is what was meant by needing a space...


-tg

[SteveHi]

Grateful thanks, techgnome

You have cracked it.

I have been on this for hours - a lesson well learnt.

Thanks again

PS: I still get this message from the board: 'You must spread some Reputation around before giving it to techgnome again.'