email button

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

Guest

I am trying to create a command button the sends the current form entry to a
specified email address, how do I do this?
 
It sounds like you want to send a particular record. See Help for the
SendObject method. I think you may want to send a report rather than a form.
You may also want to look at Exporting Report Snapshots.
 
1. create a report that contains your data you would like to send
2. in design view create a new command key utilizing the wizard
in the wizard look in the "report operations" and the action you want is
mail report complete the rest of the wizard.
3. right click on the new command key , go to "properties", "event" tab,
"on click" should read "[Event Procedure]" open the the vba for this button.
4. once in vba look in your help file under "sendobject" this should help
you costomize the rest.
 
Back
Top