View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] TheObstacleIsThePath@gmail.com is offline
external usenet poster
 
Posts: 17
Default VBCRLF not doing anything

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 = "
.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?