printing one form

[Pam]

How can I send a form through Outlook? When I try to send
it, it sends all 50,000. I only want to send the form
showing on the screen. If I choose edit, select record
and then send, it sends it but in a table setup. I want
the form to show so it can be printed this way. Help.

 

[frank stone]

I'm not sure you can do that. I tried to do the same thing
but fail. there is a send mail function in access but
sending the form wasn't an available format. i solved the
problem by creating a report the looked just like the form
and sent the report. i used this code attatch to a button
lable "send mail". It will ask for a id to identify the
record to be sent.

Private Sub cmdSendeMail_Click()
On Error GoTo Err_cmdSendeMail_Click

Dim stDocName As String

stDocName = "rptVMDForm"
DoCmd.SendObject acReport, stDocName, "RichTextFormat
(*.rtf)"

Exit_cmdSendeMail_Click:
Exit Sub

Err_cmdSendeMail_Click:
MsgBox Err.Description
Resume Exit_cmdSendeMail_Click

End Sub