HI, thanks for the course, the best I have seen.

I have been trying to insert a new line in the MsgBody after pulling the person's name so the the message is not all on the same line. I have tried the usual commands but it will not produce a new line. Can you advise?
Automating Outlook email 3 time 10:15

Tony

---

Reply from Alex Hedley:

Hi Tony what commands have you tried?

You could try vbNewLine.

There are constants in VBA like:

Constant       Definition
   -------------------------------------------------------------------
   vbBack         A backspace character [Chr(8)]
   vbCr           A carriage return [Chr(13)]
   vbCrLf         A carriage return and line feed [Chr(13) + Chr(10)]
   vbLf           A linefeed [Chr(10)]
   vbNewLine      A platform-specific new line character, either
                  [Chr(13) + Chr(10)] or [Chr(13)]
   vbNullChar     A null character of value 0 [Chr(0)]
   vbNullString   A string of value 0 [no Chr code]; note that this is
                  not the same as ""
   vbTab          A tab character [Chr(9)]