Email Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
(e-mail address removed)?
 
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
 
Back
Top