You can email a REPORT with the data from the record on your form.
I think the button wizard will walk your through emailing a report using a
button. You can do some searches on previous posts if you need help getting
the fields in the email filled in. Or use the help feature in the code
window that prompts you for the entries as you type your sendobject
statement.
Try saving your form as a report, then it will e-mail. You can also automate
this, once you have saved your form as a report, create a query with all this
info that is in your report and base the report on it. fill in critea for
one of the fields that will match the record in the query to the record on
the form.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.