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?

VBCRLF not doing anything
 

Not tested, but how about


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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
ps.com...
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?

VBCRLF not doing anything
 

You need <br

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ps.com...
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?

VBCRLF not doing anything
 

Thanks to all !!! Simple fix.

Ron de Bruin wrote:
You need <br

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ps.com...
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?