Email Stuck in Outbox!!!!

[Newguy28]

Hi Guys,

Im using the sendobject macro to email a report when the database is opened, yet when it does, the email is only in my outbox, doesnt seem to be sent to other users!!! Can anyone tell me what is going on or how to get around this??

Thanks in advance.

 

[Oldsoftboss]

Check the arguments of the SendObjects commant. One of them is to send without editing.

From Access Help:

The SendObject method carries out the SendObject action in Visual Basic.

Docmd.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile)

EditMessage: Optional Variant. Use True (–1) to open the electronic mail application immediately with the message loaded, so the message can be edited. Use False (0) to send the message without editing it. If you leave this argument blank, the default (True) is assumed.

Dave

 

[Newguy28]

Thanks, but where do i do this???

 

[Oldsoftboss]

Hi Guys,

Im using the sendobject macro

Should have read yor post a bit closer.

I was referring to the code behind an On_Click event of a command button.

Dave

 

[Dougalsworld]

Hi I'm having the same issue as above yet my edit message section is already set to false, does anyone know of anything else it could be

DoCmd.SendObject acSendNoObject, , , _
sToName, , , sSubject, sMessageBody, False , False