Extra space with vbNewLine
I guess maybe i should have mentioned that myMsg goes to the .body of an
email. Still get the spaces with the below suggestions...any other
thoughts?
The space isnt in the cell...
I think the spaces might be coming from the email program (I notice them
when I copy/paste from email messages). What if you apply the RTrim function
to the email lines that you end up concatenating vbNewLine onto. I think
like this may do for you....
myMsg = myMsg & myCell.Offset(0, -2).Value & _
" Millwork: " & RTrim(myCell.Value) & vbNewLine
and maybe here too...
myMsg = RTrim(myMsg) & vbNewLine
Rick
|