Help with code sending email in silence

[crann]

Hi Everyone

Not sure if this is possible I use the code below to send an email when a status of a drop down box has been changed, all works great but is it possible to have that email sent without opening Outlook so in other words it runs sending the email in silence?

Thank you for any help


Private Sub Combo11_AfterUpdate()

If Me!Combo11.Value <> Me!Combo11.OldValue And _
Me!Combo11.OldValue & "Pending" <> "Paid" Then
MsgBox "Status of field has changed from " & Me!Combo11.OldValue & _
" to " & Me!Combo11.Value


DoCmd.SendObject acSendReport, "Table1", acFormatPDF, "emailaddresshere", , , "An Invoice Has Been PAID", "Status Change"


End If
End Sub

 

[pbaldy]

CDO would be one way.

 

[crann]

Thanks Paul

Not sure what CDO is so will do some research.

 

[gemma-the-husky]

you could also install blat, and send your emails by calling blat.