Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compile Error in Excel 2004 when Inputbox contains "VBCRLF" | Excel Discussion (Misc queries) | |||
square boxes when using vbcrlf | Excel Programming |