SendObject text in body on 1 line

[TTD]

Hi when I send mail from Access the body puts al my bodydata on 1 line,
though the string contains carraige returns.

strMailadres = Me.Mailer

strPerson = Me.Responsable
strSubject = "Casenr. " & Me.Casenummer & " : " & Left$(Me.CaseOmschr,
20)
strText = "Casenummer: " & Me.Casenummer & Chr(13) & Chr(13) _
& " Received through:" & Me.OntvangstOmschr & Chr(13) & Chr(13) &
Chr(13) & _
" Deadline is at " & Me.Deadline & " " & Me.DeadlineTijd & " Well solve
it." & Chr(13) & _
"Greetings., " & Me.Person

'Mail verzenden
DoCmd.SendObject , , acFormatTXT, strMailadres, , , strSubject, strText,
True

Any idea how to get carriage returns in the mail?

[Rick Brandt]

"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...

Hi when I send mail from Access the body puts al my bodydata on 1 line,
though the string contains carraige returns.

You need Chr(13) & Chr(10) in that order.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Saintor]

You can use vbCrLf instead of Chr(13) & Chr(10)
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...

Hi when I send mail from Access the body puts al my bodydata on 1 line,
though the string contains carraige returns.

strMailadres = Me.Mailer

strPerson = Me.Responsable
strSubject = "Casenr. " & Me.Casenummer & " : " & Left$(Me.CaseOmschr,
20)
strText = "Casenummer: " & Me.Casenummer & Chr(13) & Chr(13) _
& " Received through:" & Me.OntvangstOmschr & Chr(13) & Chr(13) &
Chr(13) & _
" Deadline is at " & Me.Deadline & " " & Me.DeadlineTijd & " Well solve it." & Chr(13) & _
"Greetings., " & Me.Person

'Mail verzenden
DoCmd.SendObject , , acFormatTXT, strMailadres, , , strSubject, strText, True

Any idea how to get carriage returns in the mail?

[Lumpierbritches]

You might want to try vbcrlf instead of Chr(13). It works for me.

Michael

[TTD]

Thanks Rick, Saintor & Lumpierbritches.

the command vbcrlf works fine.