VBCRLF not doing anything

[TheObstacleIsThePath]

I've been scouring groups for a resolution to this, but I'm
unsuccessful. I can't get a Carriage return/line feed into an
automated email from excel. (using office 2003)


Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.HTMLBody = "first line" & vbCrLf & "next line"
.Display 'or use .Send
End With

It does what it should, but concatenates the body text without line
feeds.

any ideas? an outlook setting?

 

[Bob Phillips]

Not tested, but how about


.HTMLBody = "first line<br />next line"


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Ron de Bruin]

You need <br>

There is a example on this page
http://www.rondebruin.nl/mail/folder3/mail2.htm

 

[TheObstacleIsThePath]

Thanks to all !!! Simple fix.

You need <br>

There is a example on this page
http://www.rondebruin.nl/mail/folder3/mail2.htm