Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can you email a form??

Status
Not open for further replies.

Lee24

Programmer
Apr 11, 2001
103
GB
I am trying to let the user enter information into a form and have a button that allows them to email it to someone!

Is this possible!


Thanks

In Advance!
 
Use this

Private Sub Command2_Click()
DoCmd.SendObject acSendForm, "form2", acFormatXLS, name2, , , "My Subject text", , False
End Sub

"form2" = Name of your form
acFormatXLS = the format your sending the form as
name2 = the email address

Hope this helps.

Randy Street
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top