Access 2003 & Groupwise Email (VBA) (1 Viewer)

[Adam Caramon]

Hi all,

I've searched all corners of the Internet world for a SIMPLE way to send an automated email when a user clicks a button. The objective here being that when someone checks a box indicating that the labeled item is complete, the next person that needs to work on the project is notified.

Here's what I have:

Private Sub Command200_Click()
On Error GoTo ProcErr
   Dim stSubject As String
   Dim stMessage As String
   Dim stTo As String
 
stSubject = "blah has been updated for " & Forms!frmNameofForm![FieldName]
stMessage = "The next step is to blah"
stTo = "individual's email address is here"
DoCmd.SendObject acSendNoObject, , , stTo, , , stSubject, stMessage, False
 
ProcExit:
Exit Sub
ProcErr:
If Err.Number = 2501 Then
   GoTo ProcExit
End If
MsgBox "Error#" & Err.Number & "." & Err.Description & "- SendEmail_Click"
   Resume ProcExit
End Sub

When someone checks one of these boxes, a macro runs. One of the steps of the macro is to run the above code. It works flawlessly, automating an email with all the correct information where I want it. However, it prompts me for my signature (this is default and expected behavior because in Groupwise I have select "Prompt before adding" for my signature.

However, I would like for this module to automate answering "Don't Add" (or possibly intercept before the signature prompt is fired and bypass it)

Is there an easy way to do so?

Thanks in advance