I need to send an up arrow ↑
to an iPhone with SMS using VBA and a CDO mail object.
My attempts are as follows:
Unicode:
subj = ChrW(8593) & " Up " & ChrW(8593)
HTML:
subj = "↑ Up ↑"
Both of the above methods result in the iPhone receiving either a ? Up ?
for the Unicode or ↑ Up ↑
as a string literal.
Does anyone know the correct syntax for an up arrow ↑
?
Solution:
I was looking for some 'special character' syntax but the problem was not in the construction of the message. I needed to add
.BodyPart.Charset = "utf-8"
to the CDO.Message object and use the UnicodeChrw(8593)
where I needed it.Apparently,
.BodyPart.Charset
covers both the subject and the message body as I was able to use unicode in both.Anyone planning to use this code for their own purposes needs to add the Microsoft CDO for Windows 2000 library to their project via Tools, References.