VBA Sendobject body text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a db and i want to send emails. but in the sendobject function i want
in the body text enters how does i give that, i can only write text without
enters.

I hope someone can help me
Rogier
 
I don't know if these will work, but try vbCrLf or vbNewLine. I just tested
them with this code:

Sub Message()
Dim strMessage As String
strMessage = "Hi!" & vbNewLine & "How are you?" & vbCrLf & "Great!"
MsgBox strMessage
End Sub

Hopefully they will work in the thing you want to do also :)

- Beginner -
 
Beginner,

thanks for your expertise, you have spend me a lot of time thanks. And the
name BEGINNER you can change to EXPERT ;-)
 
:D Glad to help!

- Beginner -

Rogier said:
Beginner,

thanks for your expertise, you have spend me a lot of time thanks. And the
name BEGINNER you can change to EXPERT ;-)
Click to expand...
 
Back
Top