Emailing Submitted Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wichie - 13 Mar 2007 16:37 GMT

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.

Reply to this Message

Carl Rapson - 14 Mar 2007 16:33 GMT

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

> To all:
>
[quoted text clipped - 4 lines]
> and also emailed to specific people. Upon completion, Is it possible
> to have a form emailed to certain people? If so, how? Thank you.

Reply to this Message