Left Justify String

Hello everyone!



I have the following string of text that I currently push out to the body of an Outlook email (using the DoCmd.SendObject function with an Access report):

Code:

---

sMsgBody = "Please find attached the specified Final Costing Report for WO# " & WO & vbCr & vbCr

sMsgBody = sMsgBody & "Dealer: " & rs.Fields(0).Value & vbCr

sMsgBody = sMsgBody & "Model: " & rs.Fields(1).Value & " : " & rs.Fields(2).Value & " : " & rs.Fields(3).Value & " : " & rs.Fields(4).Value & vbCr

sMsgBody = sMsgBody & "Margin $: " & rs.Fields(5).Value & vbCr

sMsgBody = sMsgBody & "Margin %: " & rs.Fields(6).Value & vbCr

---

Which is great and works fine! It appears in the email like so:



Attachment 57695



Now, it has been requested that the data to be left justified to the widest line... so, in this scenario, it would look like this:



Attachment 57696



I've searched for ways this might be accomplished so it's always left justified to the widest line, but haven't come across any definitive solutions yet.



Any help would be greatly appreciated as always! :D

Attached Images

	Original.PNG (4.6 KB)
	Edit.PNG (4.7 KB)

Left Justify String