Help with emailing

[norton]

I'm trying to get code my access 2007 database so that it can email out a single recordset in a report or other format. Filtered by an ID field.

I'm pretty new to this and I understand that SendObject is the best method. However, I have tried hacking and slashing various scripts off forums etc.. but to no avail.

I would appreciate a bit of a step by step guide on how to do this is if anyone can assist that would be great.

with thanks
Scott

 

[BarryMK]

Search this forum on email and report there's tons of stuff including threads with step by step help.

 

[norton]

Many thanks Barry. I finally found some script that works but ... I still need to alter the code to filter a single record... my current code is:

Private Sub sendMail_Click()
On Error GoTo Err_sendMail_Click
Dim strWhere As String
Dim stDocName As String
strWhere = "fldID"
stDocName = "rptPrintRecord"
DoCmd.SendObject acReport, stDocName, , "", , , "Website Enquiry", "Please find the attached Website Enquiry for your attention."

Exit_sendMail_Click:
Exit Sub
Err_sendMail_Click:
MsgBox Err.Description
Resume Exit_sendMail_Click
End Sub

any further help would be greatly appreciated.