Anyone know how to align the message text when using SendObject? When I run the below code I get:
Project ID: 1
Project Name: Some Name
...
I'd like to get it so the values align under one another (i.e., the "1" lines up directly above the "S" in "Some").
Code:
DoCmd.SendObject , , , strTo, strCc, , "New Project Approval", _
"This is a new project that requires your approval before it can be added to the Project Management database." & vbCrLf & vbCrLf & _
"Project ID: " & Me.ProjectId & vbCrLf & _
"Project Name: " & Me.ProjectName & vbCrLf & _
"Status: " & Me.fkStatus & vbCrLf & _
"Business Owner: " & DLookup("FirstName", "Employees", "EmployeeID = " & Me.fkUserBusOwner) & " " & DLookup("LastName", "Employees", "EmployeeID = " & Me.fkUserBusOwner) & vbCrLf & _
"Project Manager: " & DLookup("FirstName", "Employees", "EmployeeID = " & Me.fkUserProjManager) & " " & DLookup("LastName", "Employees", "EmployeeID = " & Me.fkUserProjManager) & vbCrLf & _
"Proj Description:" & Me.ProjectDescription & vbCrLf & _
"Project Start: " & Me.ProjectBeginDate & vbCrLf & _
"Target Date: " & Me.ProjectTargetDate & vbCrLf & _
"% Complete: " & Format(Me.ProjectPctToComplete, "Percent") & vbCrLf & _
"Size: " & Me.ProjectSizeLKU & vbCrLf & _
"Impact: " & Me.ProjectImpact & vbCrLf & _
"Type: " & Me.ProjectType & vbCrLf & _
"Categorty " & Me.ProjectCategory & vbCrLf & _
"Group Head: " & DLookup("FirstName", "Employees", "EmployeeID = " & Me.fkUserLendingSvcGrpHd) & " " & DLookup("LastName", "Employees", "EmployeeID = " & Me.fkUserLendingSvcGrpHd) & vbCrLf & vbCrLf & _
"Project Metrics Estimates:" & vbCrLf & _
"Budget: " & Format(Me.Budget, "Currency") & vbCrLf & _
"Cost Reduction: " & Format(Me.[Cost Reduction], "Percent") & vbCrLf & _
"FTE Benefit: " & Me.FTE_Benefit, True