Creating a Space or Tab

Hi. I'm working on a Macro to take strings from a worksheet and insert them into an Outlook email. The Macro is working fine except for one thing.

I'm creating a bulleted list of text that I'm pulling from my worksheet. To create the bullet in the email, I used a bullet Dim using Char(149) in my macro and concatenate it with a string from my worksheet. I need the bullet and the string to be separated by several spaces. If I insert spaces between the bullet and the strings, in both my code, and my worksheet, the spaces do not show up in my email.

Example:

I want:
"Bullet" Text from the excel page.

I get:
"Bullet"Text from the excel page.

I'm using the simple string below to create my bullet (ascii char 149)
I've tried adding spaces (char 32) but the spaces don't show up in the email.

Please Login or Register  to view this content.

I give up on trying to create legitimate spaces in my outlook email. What I now want to do is take the easy way out by just adding a white font word to my bullet string, so it would be a bullet & "WORD" in white, giving the appearance of a space in the email.

Or, if anyone knows how I can add spaces, that would be amazing.

I'm having trouble formatting the font color of the word in this string. Can anyone help? Greatly appreciated.

Hey, I found a solution to this if anyone cares.

Adding " " to the Bullet variable creates a space...so I just did:

Please Login or Register  to view this content.