I am using the following in a number of Excel VBA macros to send out Emails.

VB Code:
  1. Sub SendMail(ByVal ToNames As String, ByVal CCNames As String,_
  2.                                 ByVal vSubject As String, ByVal vMessage As String, _
  3.                                 ByVal AttachFile As String)
  4. Dim OutApp As Object
  5. Dim OutMail As Object
  6. Const olMailItem = 0
  7. ' Sends out an Email with vMessage as the body and with the Subject as vSubject
  8. ' Sent to ToNames and CCNames, ToNames must not be blank
  9.     If ToNames = "" Then
  10.         Exit Sub
  11.     End If
  12.     Set OutApp = CreateObject("Outlook.Application")
  13.     Set OutMail = OutApp.CreateItem(olMailItem)
  14.     With OutMail
  15.         .To = ToNames
  16.         .cc = CCNames
  17.         .Subject = vSubject
  18.         .Body = vMessage & vbCr & vbCr
  19.         If AttachFile <> "" Then
  20.             .Attachments.Add AttachFile
  21.         End If
  22.         .Send
  23.     End With
  24.     Set OutMail = Nothing
  25.     Set OutApp = Nothing
  26. End Sub

The code works perfectly, however I now need to send out an email with
data on it in the form of a table

The data is in the form of a String, and two Long's.

I would like to present it neatly, but as the font is proportional I am getting
the following results

i.e.
string1 9 8
string2 10 12
pas 8 1

Can anyone offer any suggestions as to how I can embed a commend in my
message string to use a Fixed Width font, or offer any suggestions as to how
to display a neat looking table.