Email Form

B

Bexar1

I have a form that is used for entering network related problems. I would
like to add a button on the form that emails the information to a technician.
I tried this before but it sent me the entire table instead of just the
information that was entered into the current form. How would i go about
writing the code for a button that emails the form to lets say,
[email protected]?
 
C

Chris Reveille

I am going to make an assumption that you do not want to
send a report as an attachment. If so create a macro
Action Send object
Object type leave blank
Object name leave blank
Output format leave blank
To =[Forms]![nameofForm]![NameOfControl]
Subject =[Forms]![nameofForm]![NameOfControl]
Message text =[Forms]![nameofForm]![NameOfControl] limit
255 chars
Edit message Yes until you are confortable with results

I you are sending a report create a macro and use the
Sendobject command and in you report query for criteria put
[forms]![formname].[yourcontrol]

Chris
 
Top