Solved: excel/outlook create a "line-break"

[grohm]

Hi Guys!

Is there a way that i can add automaticly a new line in an automatic generated email out of excel? At the moment i have ca. 4 sentences which should be displayed in the body of the message, which works fine. the only prob is, that i want the first sentence on the first line, the 2nd sentence on the 2nd line, you see the point. at the moment it just writes it alltogehter on 2 lines total, which looks bad.

i couldn't find any info on that after an hour of research. i can't believe that this seems to be such an uncommon problem?

hopy you guys can help.

greetz

ben

[Charlize]

[VBA].TextBody = "Line one" & vbCrLf & _
"Line two" & vbCrLf & _
"Line three" & Chr(13) & _
"Line four" & Chr(13) & vbCrLf & vbCrLf & _
"Regards."[/VBA]Charlize

[grohm]

[vba].TextBody = "Line one" & vbCrLf & _
"Line two" & vbCrLf & _
"Line three" & Chr(13) & _
"Line four" & Chr(13) & vbCrLf & vbCrLf & _
"Regards."[/vba]Charlize

....works perfectly. Thanks Charlize!!!!

[Bob Phillips]

So mark it solved!