Newline Character in Access 1

[bernie10]

I have got a form that sends out an email from outlook according to email addresses in a table when a button is pressed. I have one string variable that will be the message body. Let Mailoutlook be an outlook mail item:

With Mailoutlook
   .To = rs!Email
   .Subject = "Test message- Please delete"
   .Body = mess_body
   .Send
End With

My question is how to get a newline character in the message body string.

I would have thought it would have been

mess_body = "This is the first line. \n This is the second line"

but this doesn't work. I've also tried \t, the html tag <br>, with no luck. Does anybody know the answer?

Thanks.

 

[SkipVought]

hi,

mess_body = "This is the first line." & vbCrLf &  "This is the second line"

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[bernie10]

Thanks figured it would be something easy.