Emailing Submitted Forms

[wichie]

To all:

I am developing a form for an office to fill out. I wanted to put it
into an Access database so obviously I would created the form using
Access. Once the person fills out the form and presses a submit
button, I want the information to be stored in the subsequent table
and also emailed to specific people. Upon completion, Is it possible
to have a form emailed to certain people? If so, how? Thank you.

 

[Carl Rapson]

You can't really email a form. What you need to do is create a report that
looks like your form and email the report. As for the how: in the Click
event of the submit button, open the report with DoCmd.OpenReport, passing a
string in the WhereCondition parameter to limit the report to just the
record(s) you want. Then, in the very next line, use DoCmd.SendOutput to
email the open report. After that, you can close the report.

If you search these newsgroups (most likely the Reports group), you'll find
lots of examples. The on-line Help for OpenReport and SendObject also has
more information.

Carl Rapson