QUOTE(Windmu20 @ 27 Dec, 2006 - 07:28 PM)
I am very new to visual basic. I spent awhile trying to figure this out. I was able to send the email but I would like to disable a message. It tells me that someone is sending an email on my behalf. I then have to hit yes to proceed. I would also like the command button to go gray when I hit the button. In addition to that, I would like to check a check box. I have searched for the commands, my problem is getting the syntax inbween correct.
Private Sub SEND_Click()
SEND.DisableOOMWarnings = True
DoCmd.SetWarnings False
DoCmd.SendObject acReport, "User request form", "HTML(*.html)", "rdwind@ibtco.com", "", "", "test", "test", False, ""
SEND.DisableOOMWarnings = False
'Requery checkbox to show checked
'after update statement has ran
'and disable send mail command button
checkbox.Requery
checkbox.SetFocus
Send.Enabled = False
End Sub
Thank you Rick
)
| 