Send values on form by email

[djeeten]

Hi,

In my program, I have this form where a customer can suggest a new product.

---------------------------
Name: .....
Definition:.....
Maximumprice:.....
Note:.....

--------------------------

But now, I would like the information on this form to be emailed. Does anyone know how I could do this.

I can start an email client (and address an emial to the person I want, with the subject I want), but I don't know how to send the information on the form with it.


Thanks a lot in advance,

dj.

 

[djeeten]

I solved the problem,


Thanks anyway


This happens to me almost all the time, I'm looking for a solution for hours before posting it here, and half an hour later I figure it out myself :s . Sorry for the waste of space webmaster

I'll just post what I needed (maybe it 'll be useful for someone):

Dim strMessage As String

strMessage = "Name product: " & Me!NameProduct & vbCrLf
strMessage = strMessage & "Definition product: " & Me!ProductDefinition & vbCrLf
strMessage = strMessage & "Maximum price: " & Me!MaximumPrice & vbCrLf
strMessage = strMessage & "Note: " & Me!Note

DoCmd.SendObject acSendForm, "frmNewOrder", acFormatRTF, "emailaddress", , , "Definition", strMessage, False


dj.