With this code I get some lines that don't quite react the way I want it to. The output is generally the way I want it.
For example with this code may have a length that will wraparound: & "Notes: " & Chr(9) & Chr(9) & Chr(9) & NOTES & vbCrLf _Code:strBdyMail = strBdyMail & "Date Issue Identified: " & Chr(9) & Chr(9) & [Dates] & Chr(9) & Chr(9) & "Days Open:" & Chr(9) & DaysOpen & vbCrLf & vbCrLf _ & "Priority: " & Chr(9) & Chr(9) & Chr(9) & P1 & vbCrLf _ & "CR Number: " & Chr(9) & Chr(9) & Chr(9) & OOBNumber & vbCrLf & vbCrLf _ & "AO Recommendation: " & Chr(9) & Chr(9) & AOVote & vbCrLf _ & "O6 Recommendation: " & Chr(9) & Chr(9) & O6Vote & vbCrLf & vbCrLf _ & "Change Requested: " & Chr(9) & Chr(9) & [ChangeRequested] & vbCrLf & vbCrLf _ & "Unit & Section: " & Chr(9) & Unitss & vbCrLf _ & "MTOE Para & Bumper: " & Chr(9) & Chr(9) & [MTOEParass] & vbCrLf & vbCrLf _ & "Rationale: " & Chr(9) & Chr(9) & Rationale & vbCrLf & vbCrLf _ & "Notes: " & Chr(9) & Chr(9) & Chr(9) & NOTES & vbCrLf _ & "Action Items: " & Chr(9) & Chr(9) & ActionItem & vbCrLf _ & "__________________________________________________________________________" & vbCrLf & vbCrLf
What I get:
Notes:Tab.....Tab.....nxewuhdwehffchqiheiferwqhdui weqfuiwefiewfuwhfiewh
xioqwjndiwnfoew
What I want
Notes:Tab.....Tab.....nxewuhdwehffchqiheiferwqhdui weqfuiwefiewfuwhfiewh
tab.....Tab.....Tab.....xioqwjndiwnfoew
Its being nitpicky I know.
Any suggestions?