emailing from access asking if want to send

[Donn]

Have a macro that send several files as attachments
(excel or snap). Have to click OK to send for every file
to every recipient. Would like to have access or outlook
not ask if I want to send the fie.

 

[Jim/Chris]

I got this from a previous post.

"The security dialogs that pop up when an application tries
to access
certain Outlook properties and methods are designed to
inhibit the spread of
viruses via Outlook;
seehttp://www.slipstick.com/outlook/esecup.htm#autosec.
If you are a standalone user, Outlook provides no way to
suppress this behavior. However, you can use a free tool
called Express ClickYes:

(http://www.express-soft.com/mailmate/clickyes.html)

to click the security dialog buttons automatically. Beware
that this means
if a virus tries to send mail using Outlook or gain access
to your address
book, it will succeed.

Jim