Userform .htmlBody problem

[Antonio12]

Hello Everybody:

I have a problem with a userform text. The user completes the userform and clicks send. The email is sent and it arrives to email destination.

My problem is with the text. I have 3 textboxes 2 comboboxes. All I want is for the email to arrive with info separated by paragraphs and not spaces. This is what I have and I cant get this to work:


.HTMLBody = "Cliente: " & vbcrf & txtbox1 & " Contacto: " & vbcrf & txtbox2 & " Observações: " & vbcrf & txtbox4 & " Criado Para: " & vbcrf & Combobox1 & " Criado Por: " & vbcrf & Combobox2


Please HELP!!! I know it sounds idiotic for you guys with experience but I've been trying to get around it and it is impossible.

 

[VoG]

That should be vbCrLf or vbNewLine.

 

[Kyle123]

Try using the following instead of vbcrf - remove the spaces, the board doesn't like html "< br / >"

 

[Antonio12]

Thank you for the reply. I'm not sure if it just didn't work or if I didn't understand. Is this what you suggested:

.HTMLBody = "Cliente: " & txtbox1 & " Contacto: " & txtbox2 & " Observações: " & txtbox4 & " Criado Para: " & CB1 & " Criado Por: " & CB2
.Send

When I did this the email came blank. I Also tried:

.HTMLBody = "Cliente: " & txtbox1 & vbNewLine & " Contacto: " & txtbox2 & vbNewLine &" Observações: " & txtbox4 & vbNewLine & " Criado Para: " & CB1 & vbNewLine & " Criado Por: " & CB2
.Send


Didnt work either. Any suggestions?

 

[Norie]

You aren't using any HTML code so use Body instead of HTMLBody.

Or use Kyle's suggestion.

 

[VoG]

That should work. What does this return

MsgBox "Cliente: " & txtbox1 & vbNewLine & " Contacto: " & txtbox2 & vbNewLine &" Observações: " & txtbox4 & vbNewLine & " Criado Para: " & CB1 & vbNewLine & " Criado Por: " & CB2

 

[Antonio12]

The following worked:

.Body = "Cliente: " & txtbox1 & vbNewLine & " Contacto: " & txtbox2 & vbNewLine & " Observações: " & txtbox4 & vbNewLine & " Criado Para: " & CB1 & vbNewLine & " Criado Por: " & CB2
.Send

Thank you so much guys!!!!