docmd.sendobject problems... oy

[redbull]

So I am trying to send an email filled with alot of record based information.

DoCmd.SendObject acSendNoObject, stDocName, acFormatXLS, r!email, , , stSubject, "Client Name: " & r!ClientNumber & " - " & r!ClientName & vbCr & "Project Type: " & r!ProjType & vbCr & "Date Completed: " & r!DateCompleted & vbCr & "Software Name: " & r!SoftwareName & vbCr & "Vendor Name: " & r!Vendorname & vbCr & vbCr & "URL Generated: " & r!URLCreated & vbCr & vbCr & "URL Creation Date: " & r!DateURLCreated




the code seems to work, however it is opening the email and making the user press the send button before it will continue thru the code. I have tried tacking on a true or false to the end of the docmd.sendobject process but it is not automatically sending. Any ideas?

[redbull]

if the code would advance to the next line, I could do something cheezy like send keys... but it will not.

[redbull]

Figured it out... im an idiot.

[JrMontgom]

Microsoft has put security precautions in the automatic sending of emails so it always forces the user to press the Send menu choice.