Email with a continous form.

[lilbit27]

Is there a way to send a email within a continous form.

I have over 400 records and I want the use to hight the recordselector
and then click on an email button that that will open up email and only
put the item that is selected in the body.

Any thoughts.

 

[Jeff C]

You will need to create a query as the record source for your form, then you
will need to create a report that holds the information you want to send.
One way is to open your form and "SaveAs" a report. You will then have some
minor formatting changes to make to the report but basically it will look
just like the form you have. The report must use the query you created as
it's record source too.

You will then need to insert criteria into one of the fields of the
query/record source that defines the current record you have open in your
form.

Then place a command button on your form and use the sendObject method to
send the report you just created to the person you want.

If you want the report in the message body of the email you will need some
more coding using the mailenvelope item