Set Outlook warning off?

[vodkaready]

Hi,
I'm trying to email excel spreadsheet as attachment from the MSAccess2003
using DoCmd.SendObject, but it pops the message box up telling that the "...A
program is trying to automatically send e-mail on your behalf. Do you want to
allow this?" How do I set this warning off?
Thank you.

 

[Roady [MVP]]

There is no direct way to do this. Is there a direct need to do this? You
can allow the action for x minutes to run your script.

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-FREE tool; QuickMail. Create new Outlook items anywhere from within Windows
-Properly back-up and restore your Outlook data

-----
Hi,
I'm trying to email excel spreadsheet as attachment from the MSAccess2003
using DoCmd.SendObject, but it pops the message box up telling that the
"...A
program is trying to automatically send e-mail on your behalf. Do you want
to
allow this?" How do I set this warning off?
Thank you.

 

[vodkaready]

Thanks for the response,
Here’s what I’m trying to do:
OnTimer event of the hidden form a query will clean a data in the table, and
then other query appends new data from the linked spreadsheet. When data has
been appended I use the DoCmd.SendObject to email it as an excel attachment
to a group of people.
I’ve tried doing it with Outlook 2000 and it didn’t pop any warnings up.
Is there any work around?
Thanks again.

 

[Roady [MVP]]

Outlook 2000 also has this prompt but only with the e-mail security update
installed (included in SP3 as well).
One solution is to program with Redemption;
http://www.howto-outlook.com/redirect.asp?id=dmitry_redemption

For additional solutions ask in the programming newsgroup;
outlook.program_vba

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-FREE tool; QuickMail. Create new Outlook items anywhere from within Windows
-Properly back-up and restore your Outlook data

-----

Thanks for the response,
Here's what I'm trying to do:
OnTimer event of the hidden form a query will clean a data in the table,
and
then other query appends new data from the linked spreadsheet. When data
has
been appended I use the DoCmd.SendObject to email it as an excel
attachment
to a group of people.
I've tried doing it with Outlook 2000 and it didn't pop any warnings up.
Is there any work around?
Thanks again.

There is no direct way to do this. Is there a direct need to do this? You
can allow the action for x minutes to run your script.

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-FREE tool; QuickMail. Create new Outlook items anywhere from within
Windows
-Properly back-up and restore your Outlook data

-----
Hi,
I'm trying to email excel spreadsheet as attachment from the MSAccess2003
using DoCmd.SendObject, but it pops the message box up telling that the
"...A
program is trying to automatically send e-mail on your behalf. Do you
want
to
allow this?" How do I set this warning off?
Thank you.