Example using a double click from a text field on the form
Private Sub Emailaddr_DblClick(Cancel As Integer)
On Error Resume Next
If Emailaddr.Text = "" Or Len(Emailaddr.Text) = 0 Then Exit Sub
Subj$ = "RE: Order#" & Ordernum.Value ' something for subject
Body$ = UserId.Value & " " & "Whatever text you want to put here"
' the Body$ above could contain references to any field
' on your form that you want to include in your message.
' just format the string to your specs and the data will be included
' in the body of the message.
' the .Value reference pulls the data from the field withour the
' nasty ...not have focus error
DoCmd.SendObject , , , Emailaddr.Text, , , Subj$, Body$ , True
If you were using this from a button or some other command not within the actual fields you are pulling from, be sure to use the .Value reference instead of the .Text reference.
Originally posted by mandmlech
Does anyone know how to create a carriage return in an email message?
I have a message that I can send, but I want to have a space between the body of the text and the signature.
vbCrLf --> Enters a carriage return and goes to the next line