I am in dire need of assistance! I need to email a report, but isolate the one record. Similar to having a form open, with multiple records then printing only 1 record. I need to do this, but with email. Below is the code to print a report of the current record, I need to email a report of the current record. Any ideas? Thanks in advance!
Dim stDocName As String
Dim strwhere As String
stDocName = "rptRef"
strwhere = "[PtNum]=" & Me!PtNum
DoCmd.OpenReport stDocName, acNormal, , strwhere
I don't know how to email the current record with the docmd.sendobject function. Anyone know?