PDA

View Full Version : Solved: excel/outlook create a "line-break"



grohm
05-03-2007, 01:22 AM
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
05-03-2007, 02:19 AM
.TextBody = "Line one" & vbCrLf & _
"Line two" & vbCrLf & _
"Line three" & Chr(13) & _
"Line four" & Chr(13) & vbCrLf & vbCrLf & _
"Regards."Charlize

grohm
05-03-2007, 03:58 AM
.TextBody = "Line one" & vbCrLf & _
"Line two" & vbCrLf & _
"Line three" & Chr(13) & _
"Line four" & Chr(13) & vbCrLf & vbCrLf & _
"Regards."Charlize



....works perfectly. Thanks Charlize!!!! :beerchug:

Bob Phillips
05-03-2007, 04:06 AM
So mark it solved!