MS Access 2007 Attachment Field

[ammodog6942]

Right now I am using this to send an email from a form:

Private Sub Command76_Click()

Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String

strSubject = Me.Title
strToWhom = "Email Address"
strMsgBody = Me.Commentary

DoCmd.SendObject , , , strToWhom, strToCCWhom, , strSubject, strMsgBody, True

End Sub

I would like to be able to include the file(s) from the Attachment field in the email. Can anyone direct me into how I can accomplish this? Thank You

 

[MajP]

If you found a better solution please reply. If not here is how I did it:
thread705-1645879