You can use a program called "Click Yes" which when authorized will click
the button  for you.

http://www.contextmagic.com/express-clickyes/

Thanks. It really works...............

I think you're referring to the msgbox that pops up and says: "A
program is trying to access e-mail addresses you have stored in
Outlook." I get that when trying to do mail  merge with Excel/Word
and using Outlook to send  emails.
There is no direct way to disable this feature; if you have Outlook
2000 or higher it may be installed and turned on by default. If you
are using Outlook with an Exchange server, your network
administrator would have to turn off the feature. This would
compromise security should your system acquire any viruses. There
are some ways to code around it and you can also send email other
ways, but I'm not really sure how it works.

There are programs that claim to bypass this or assist in
automating, ClickYes is one of them. Check it out here:

http://www.contextmagic.com/express-clickyes/

The best way to send automated  emails is to simply avoid Outlook! Try
using a third-party SMTP library like Ostrosoft's COM. You can
download a free version at http://www.ostrosoft.com/products.asp.

1. download smtp_component.zip
2. from downloaded file unzip OSSMTP.dll to Windows System directory
3. run "regsvr32 OSSMTP.dll" from command-line
4. In Excel's IDE, Select Tools->reference to select the Ostrosoft
SMTP Component.

Then, you can run a module like this:
Option Explicit

Sub testEmail()
Dim SMTP As SMTPSession.SMTP

Set SMTP = New SMTPSession.SMTP
SMTP.Server = "Server.COM" 'Find from Outlook's Tools->Options
' mail  Setup Tab and click  Email Accounts. Then click next to
' find your POP/SMTP server name


SMTP.MailFrom = "d@..."
SMTP.SendTo = "f@..."
SMTP.MessageSubject = "Sample report Report"
SMTP.MessageText = "Test Message"
SMTP.Attachments.Add "C:\Report 1"
SMTP.Attachments.Add "C:\Report 2"
SMTP.SendEmail
Set SMTP = Nothing

End Sub