MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Automated Emails Message box

  Asked By: Viveka    Date: Mar 18    Category: MS Office    Views: 1889

When ever we send automatted mails one message box pop-ups
stating/confirming if you like to send automatted mail by prompting us
to click on yes/no or cancel button. Can we not stop this for
automatted mails send through excel sheet?.

If any one has solutions to this please let me know.



4 Answers Found

Answer #1    Answered By: Waggoner Fischer     Answered On: Mar 18

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


Answer #2    Answered By: Davi Costa     Answered On: Mar 18

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

Answer #3    Answered By: Sydney Thompson     Answered On: Mar 18

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:


Answer #4    Answered By: Kim Cruz     Answered On: Mar 18

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()

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"
Set SMTP = Nothing

End Sub

Didn't find what you were looking for? Find more on Automated Emails Message box Or get search suggestion and latest updates.