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!
Automatic email
- Thread starter Lv2valt
- Start date
ok this is what I did on a project
1) create a report that holds the info you want to email.
2) in design view put a button on your form that the info is coming from.
3) when the wizard comes up select report operations>mailreport
4) after the button is create go to the coded behind the button and bfore the DoCnd.SendObject Report "Report_Name" add a DoCmd.Save Form "Form_Name"
That will work.
Note: You also wnat to do any calculations and everything before the DoCmd.Save
and you want the DoCmd.SendObject Last
HTH
1) create a report that holds the info you want to email.
2) in design view put a button on your form that the info is coming from.
3) when the wizard comes up select report operations>mailreport
4) after the button is create go to the coded behind the button and bfore the DoCnd.SendObject Report "Report_Name" add a DoCmd.Save Form "Form_Name"
That will work.
Note: You also wnat to do any calculations and everything before the DoCmd.Save
and you want the DoCmd.SendObject Last
HTH
- Status
Similar threads
