How to email only one record in a form

[kmdru]

Hi There!

In my database at work, the staff fill in a particular form, and when it is completed, I want to have a command button in the form so they can email the form to someone else. I tried using the DoCmd.SendObject function to send the form, but it sends all the records in the form! What am I missing? What do I need to do to send only the active form/record? Any assistance/information would be greatly appreciated

kmdru

 

[Ctrler]

On your data entry form, create a button committed to the following macro:

RunCommand, SaveRecord
OpenReport, PrintPreview WHERE [RecordNr]=[Forms]![DataEntry]![RecordNr]
SendObject
Close

The condition in OpenReport limits the output to the record showing currently on your form.
In SendObject, you can add default e-mail addresses and choose a suitable format, such as RTF. If you set 'Allow Message edits' to 'no', the e-mail will be sent automatically, while 'yes' allows the user to edit the message before sending.

Regards, Gion

 

[kmdru]

Thanks Gion!

I had no idea it was so easy. It worked like a charm. The only problem now is that when I mail it as RTF, the information is scattered about on the pages. But I can work on that, or try other formats.

Thanks again for your help.

kmdru