Email current record as rich text

  • Thread starter Thread starter David Wagner
  • Start date Start date
D

David Wagner

I was wanting to know if anyone could help me on a database I am working
on. I want to be able to place a command button on a form that will email a
access report which only contains the current record that I am viewing. I
know in access now I can email an entire report but that can be to large and
there is really no reason for the recipient to see all the records just the
one i want them to see. Also i would like it sent as a rich text attachment
or word doc. I am using access 2003. Thanks for any help you can give me.
Take care.

Dave W.
 
hi,
The sendobject command was not set up to send the
contents of a form. an object is a query, report or form
but NOT the contents of a form. (believe me. i have
already spent some time tring to do this)
my solution:
i crated a report that looks like the form. I created a
query for the report that asked for the autonumber of the
last record input. The query ran, populated the report
with the last record input and the report was emailed. i
used the following code. this has been working now close
to 4 years. no user complaints yet.(cross fingers)

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

good luck
Frank
 
Back
Top