I haven't tried this yet, but you might try putting the "sending code"
into Outlook, then calling that sub from Excel. If it's in Outlook, it
should be trusted and the security prompt should be avoided.

HTH,
JP


On May 10, 2:15 am, Yongy wrote:
Dear Ron,

I need to let my user to send email automatically without any alert or
dialog display.

Please recommend VBA code to prevent displaying dialog to send or not send
when I put .send code insted of .display and Application.SendKeys "%S"
according to your recommendation onhttp://www.rondebruin.nl/mail/prevent.htm.

Thank you and regards,

Yongy