Forms and emailing

[mlamont]

I have a form that asks people to enter in certain information. What I would like to have happen is when the user clicks on a button some of the information in that form is emailed to an email address. Is that possible?

If anybody can help me, I would be extremely grateful.

Cheers,

Mike

 

[Travis]

See "SendObjects"

 

[mlamont]

Multiple fields in an email

Thank you very much for that tip. I researched it and it would appear to work, I just need to know how to add multiple fields in an email. Right now I can only get 1 field to be displayed in an email using the SendObjects action.

Can anybody help me?

 

[Travis]

Dimension a String Object and populate it with the info that you want:

Dim stMsg as String

stMsg=Me.[Text Field 1] & vbcrlf & Me.[Text Field 2]

docmd.SendObject acSendNoObject,,,"TO",,,"Your Subject",stMsg