Email to a Blackberry

[Richard]

I have a customer complaint form that I want to be able to fill out and send
the contents of the form to a Blackberry as an email, not as an email with an
attachment. Can this be done?

 

[John Nurick]

Hi Richard,

You'll need to assemble the values of the fields into a string variable,
with line breaks and whatever else you need to make it comprehensible.
Then use this as the body of a message to be sent with DoCmd.SendObject.

(This should work unless the message is so long that it would be no fun
reading on a Blackberry anyway.)

Air code:

Sub TestSendObject(Email As String)
Dim strSubject
Dim strMsg As String

strSubject = "Complaint " & Me.ComplaintID.Value
strMsg = "Customer: " & Me.FirstName & " " & Me.LastName _
& vbCrLf & vbCrLF
strMsg = strMsg & Me.ComplaintText

DoCmd.SendObject acSendNoObject, , , Email, , , _
strSubject, strMsg, False

End Sub