Email Line Feeds (1 Viewer)

Thales750

Formerly Jsanders
Local time
Today, 06:55
Joined
Dec 20, 2007
Messages
2,061
Hey Guys,

Any idea why this isn't line feeding?

Code:
            .HTMLBody = "A new NCR Request " & lngSourceID & " has been created!" & vbCrLf & vbCrLf & " Source: " & DLookup("sSource", "tblSources", "sSourceID = " & lngSourceID) & vbCrLf & vbCrLf & _
                        "Location: " & DLookup("sLocation", "tblSources", "sSourceID = " & lngSourceID) & vbCrLf & vbCrLf & "Notes: " & DLookup("sSourceNotes", "tblSources", "sSourceID = " & lngSourceID)

Thanks
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:55
Joined
Aug 30, 2003
Messages
36,118
As you've found, with an HTML body you have to use HTML tags, the vbCrLf won't work. I've got code that can go either way so I set a variable to one or the other that gets used from then on.
 

Users who are viewing this thread

Top Bottom