Line Return

  • Thread starter Thread starter Don Rountree
  • Start date Start date
D

Don Rountree

I am coding in VBA, a button to email a report. I am
setting it up to fill in the message body. I am at the
end of my text, but I want to skip a line and then code
in the name of the person sending the email. How do you
enter a carriage return in VBA so that I can program a
blank line into my email like I did at the bottom of this
message? Any help would be appreciated.

Don Rountree
 
Don, when you are at the end of your text you can type in
the following; & vbCrLf & vbCrLf &
The first vbCrLf will give you the first carriage return
(empty line) and the next vbCrLf will give the second
carriage return line.
The vbCrLf stands for Carriage return Line feed.
Hope this works.
*** John
 
Back
Top