Aligning text in an Outlook message via VBA

[djsmitherman]

Howdy.

I'm sending an e-mail using the SendObject command. I build a text string
through a series of statements, and then reference that string as the message
text in the SendObject command.

When I preview the resulting e-mail message in Outlook, the columns of
numbers are aligned just as they are in the statements in VBA. When the
e-mail is sent, and viewed in other e-mail clients, the columns are not lined
up.

Apart from using HTML format (some recipients may not have e-mail clients
capable of rendering HTML), are there any formatting I can force in the VBA
code? Or in the Outlook settings?

Thanks for your help.

Danny

 

[Eric Legault [MVP - Outlook]]

The formatting of the string you pass to the MessageText parameter is all up
to you using VBA; there's nothing in Outlook to help you with this.

You'd have to code the formatting of the string very carefully using string
constants (such as vbCrlf, vbCr, vbTab, vbLf, etc.) to output your data
results properly in Plain Text messages.