• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

Email strips crlf and replaces with spaces

I have a piece of code that sends out emails, it works absolutely fine except when I want to include crlfs in the body. It replaces them with spaces. Well actually, the first crlf works OK, but the ones after the first do not. I wonder if that is important?

In other applications, I'm inserting the emails into an Oracle table, then using an email application that runs every 30 mins to check this table and send out any pending emails. When I am originally inserting the email into the table, I'm using the vbCrLf character if that makes any difference.

The code is below and if you want to test it, you can use something like this for the body of the email:

Customer ID: 123456
Customer Name: TOOL & EQUIPMENT SUPPLIES
Order ID: C12345
Order Amount: $500.00
Requested By: BRANEY

If you notice in the code below, the debug.print line checks what it is right before it sends and it seems to be perfectly fine at this point. I've also tried it as an HTML email and that doesnt work either.
Private Function SendEmail(ByVal strTo As String, ByVal strSubject As String, ByVal strBody As String, ByVal strAttachment As String, ByVal strFrom As String, Optional ByVal CCTo As String = "") As Boolean
 
        ' Take the parameters passed in the function and create an email message
        Dim oMessage As MailMessage = New MailMessage(strFrom, strTo, strSubject, strBody)
 
        oMessage.IsBodyHtml = False
 
        ' Does the message have a cc address?
        If CCTo <> "" Then
            oMessage.CC.Add(CCTo)
        End If
        
        ' Does the message have an attachment?
        Dim oAttachment As Attachment = Nothing
        If strAttachment <> "" Then
            oAttachment = New Attachment(strAttachment)
            oMessage.Attachments.Add(oAttachment)
        End If
 
        Try
            Dim oClient As New SmtpClient(My.Settings.SMTPServer, My.Settings.PortNumber)
 
            Debug.Print(oMessage.Body)
 
            oClient.Send(oMessage)
 
            ' Release the attachment if it exists
            If oAttachment IsNot Nothing Then
                oAttachment.Dispose()
                oAttachment = Nothing
            End If
 
            ' Email sent successfully
            Return True
 
        Catch ex As System.Net.WebException
 
            ' Email Failed
            Console.WriteLine("0", ex.Message)
            Console.Write("0", ex.ToString())
            Return False
 
        End Try
    End Function

Open in new window

0
braney
Asked:
braney
  • 2
1 Solution
 
burningmaceCommented:
Try replacing the vbCrLfs with the <br /> HTML tag. For example "Customer Name: Bob<br />Order Total: $500". I think the SmtpClient defaults to HTML email these days - but don't quote me on that.
0
 
braneyAuthor Commented:
Worked great that, thanks!

I just switched it to

oMessage.IsBodyHtml = True

and added a line before it makes the message

strBody = strBody.Replace(vbCrLf, "<br />")

and seems to have worked fine!
0
 
burningmaceCommented:
Glad to be of help :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now