SendObjects

[EeOr]

Hi does anyone know if there is a way to supress the warning box that comes
up when sending a report using the vba DoCmd.Sendobject?

Thanks

Jon

 

[Rick Brandt]

Hi does anyone know if there is a way to supress the warning box that
comes up when sending a report using the vba DoCmd.Sendobject?

The message comes from Outlook, not Access and about the only way to not get
it is to not use Outlook. Office 2007 apparently gets rid of the message if
the system has up to date anti-virus installed.

There is a utility that will automatically click the 'OK' for you. I use
code to send messages with CDOSys to avoid security prompting, but you can't
display the outgoing message and you don't get a copy in Sent Mail.

 

[EeOr]

Hi Rick, thanks for this. would you be able to give me sample code for
this, as I do not require the outgoing message to be displayed and also do
not require a copy in the sent items.

Thanks again,

Jon