Multiple lines in email from Access
Posted on 2004-11-17
I am trying to send an email from Access through Outlook.
It all works, but I can't get it to send with multiple lines.
I have tried everything I can think of. vbcrlf, chr$(13), vbcr+vblf, "/n"
None of it works, it just ignores those characters, and puts it all on one line.
Dim sBuffer as String
Set obj = mobjOut.CreateItem(olMailItem)
sBuffer = "Line 1" +vbcrlf + "Line 2"
obj.HTMLBody = sBuffer
obj.To = sEmail
obj.Subject = "Example"