E-mail macro question

[gary g]

When the end user completes making entries in a form, I would like the user to be able to forward a copy of the completed form via e-mail. I know I can create a button on the form utilizing the SendObject macro and set the applicable action arguments, but this creates the following issue.

When the user clicks the button to send e-mail, the e-mail program automatically attaches copies of all the forms in the DB (118 total), instead of just forwarding the specific form the user just completed. Is there a way to limit the attachments to just the one form I want the user to send?

Someone mentioned I might be able to include a filter as part of the SendObject macro, but having never used filters opens up a whole new world of uncharted territory for me. To begin with I am not sure what fields I would be filtering since the user is initially entering data into a blank form.

Can anyone shed some light on the best way to make all this happen? Maybe with a few pointers I'll be able to muddle my way through. Appreciate any feedback!

 

[pbaldy]

For starters, I'd send a report, not the form, as you have much more control over the formatting of a report. There is no filter argument in SendObject. You can use this technique to filter the report when it gets sent:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

You can also open the report filtered:

http://www.baldyweb.com/wherecondition.htm

then send it, then close it again. I'd use the first method. You can also base the report on a parameter query that gets the key value from the form, but that to me makes it less flexible.