Aligning text in an Outlook message via VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top