sendobject is stuck in outlook

[Jean-Paul]

Hi,
I have this:

DoCmd.SendObject acSendReport, "Planningverslag", acFormatSNP, ........

in my code.
This sends a report to somebody.
This report however is send to outlook mailbox out.
I want it to be send immediatly, without me having to open outlook to
get it send.

But.... How?

Thanks

 

[Rob Parker]

Hi Jean-Paul,

You need to set the EditMessage parameter (it's the ninth one) in the
SendObject call to False. If you simply omit it, it defaults to True, and
Outlook will open the message to allow you to edit it.

You will likely still be presented with a message box saying that something
is trying to use Outlook to send a message, and will need to respond to
that. If you want to get rid of that too, have a look here:
http://www.dimastr.com/redemption/

HTH,

Rob