Excel remove blank rows in Email

[Nothnless]

Hi Guys,

I'm setting up an email template using some VBA where the following in displayed in the email:

Range("B11").Value & " " & Range("C11").Value & vbCrLf & _
Range("B12").Value & " " & Range("C12").Value & vbCrLf & _
Range("B13").Value & " " & Range("C13").Value & vbCrLf & _
Range("B14").Value & " " & Range("C14").Value & vbCrLf & _

How can I make it so if cells B12 and B13 are blank then the data in the email will display like this:

Range("B11").Value & " " & Range("C11").Value & vbCrLf & _
Range("B14").Value & " " & Range("C14").Value & vbCrLf & _

 

[Michael M]

Maybe something like this
But it may not work if the rest of the code affects the IF statement

If Range("B12").Value = "" And Range("B13").Value = "" Then
    Range("B11").Value & " " & Range("C11").Value & vbCrLf & _
    Range("B14").Value & " " & Range("C14").Value & vbCrLf & _
else
    Range("B11").Value & " " & Range("C11").Value & vbCrLf & _
    Range("B12").Value & " " & Range("C12").Value & vbCrLf & _
    Range("B13").Value & " " & Range("C13").Value & vbCrLf & _
    Range("B14").Value & " " & Range("C14").Value & vbCrLf & _
end if