Send email without edit

[Malcy]

Hi
I am trying to put in some automated email responses to advise of changes within a database.
It seems to go fine, except each time it opens up an Outlook edit form waiting for the <Send> button to be clicked.
I want these emails to go quietly without advising the operator that they have gone but cannot get away from the Outlook bit opening up. Any thoughts?
My (anonymised) code is

            DoCmd.SendObject , , , "1@blurb.co.uk", , , "Database - Authorised staff password alteration ", "Dear David," & vbCrLf & "A successful attempt to change a member of staff's password has just been made in the MgmXxx database. The master password was entered correctly so the database record has been changedto reflect the new password." & vbCrLf & "The member of staff making the change was " & intStaff & " and they changed the password for " & intStaff1 & ". " & vbCrLf & "The new password is now effective." & vbCrLf & " " & vbCrLf & "Automated database administration"

Any help most appreciated, as always!
Thanks in adbvance and best wishes

 

[Oldsoftboss]

You haven't delved quite deeply enough with the sendobjects code.

DoCmd.SendObject , , , , , , , , False

Count the commars, the false means Edit Message - True/False !

Dave

 

[Malcy]

Thanks for the help.
That cuts out the opening to edit. I thought I had enough commas but clearly not.
However ...
I now get an Outlook message
"A program is trying to automatically send an email on your behalf. Do you want to allow this? If it is unexpected, it may be a virus and you should choose no."
Given the message is really to be sent quietly and not be seen by the user this rather defeats the purpose since they could be forgiven for saying "ouch" and hitting no - which will stop the email going.
Any ways around this that anyone knows of???
BTW I am using Windows XP Pro, Outlook 2003 and Access 2003. I suspect it may not be an issue with earlier versions
Best wishes

 

[workmad3]

see the thread titled "Program Sending Mail on your behalf" for some answers to this problem

 

[scoop10000]

Redemption

Try

http://www.dimastr.com/redemption/


This will help you

 

[Oldsoftboss]

Download redemption looks like an answer.

Note....
I get the same error msg, if if cancelled, access throws up an error that needs trapping .

It never ends.

Dave

 

[leozam]

I need your help

How can I see the tread titled "Program Sending Mail on your behalf"

see the thread titled "Program Sending Mail on your behalf" for some answers to this problem