Add True to the end of your code to make it send automatically.
DoCmd.SendObject acSendQuery, stDocName, acFormatXLS, EmailAddress, , , "Outstanding Orders", "Please find, attached, your outstanding orders." & vbCrLf & vbCrLf & "Regards.", True
This should work now.